cancel
Showing results for 
Search instead for 
Did you mean: 

Filter data by value or specific line - SAC

AngelMesp
Explorer
0 Kudos
244

Helo experts,

I am trying to filter a table when the value of a measure is equal or higher than the value chosen by the user.

At the moment I can detect when it is higher or lower, but I cant filter by those lines and hide the ones that don't meet the criteria.

What I'm trying to do is after detecting which lines meet the criteria, save the ID of all the dimensions and filter the table, but this keeps showing me lines that I don't need.

What can I do?

Cheers

View Entire Topic
N1kh1l
Active Contributor

@AngelMesp 

May be you can create a calculated dimension using value based dimension. Use measure value range to define the dimension values and then use this dimension to filter the table.

N1kh1l_0-1707308510048.png

 

Br.

Nikhil

AngelMesp
Explorer
0 Kudos

Hello @N1kh1l

I tried to do but its a live model. I cant create a value based dimension measure.

Thanks for your help.