Forum Discussion

sjpbi's avatar
sjpbi
Frequent Visitor
2 years ago

How to filter table based on rank measure?

Hi I have an issue filtering my table based on rank value, I have this scenario:   When the user select a sample size %, the table should filter based on the rank (data_filter measure)  Total Dat...
Dashboards
Data Modeling
Reports
sjpbi's avatar
sjpbi
Frequent Visitor
2 years ago

Data should filter only 3 rows  since it's 18*15%=2.7=3

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi sjpbi ,

 

I'm trying to create a measure for the filter to filter out columns with a value of 1,and getting the result:

 

For visual = IF('Table'[data_filter]<='Table'[For data_filter],1,0)

An attachment for your reference. Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.