Issue: Getting Top 5 Max filtered values

[Anonymous]

Hi all,

I have two columns col1 and col2, i am trying to get a top 5 maximum values from col2 on the basis of col1 value => "0".
Hers is the example of my solution:

 col1                                                                 col2

1	0.0856
0	0.98
3	0.99
7	0.97
0	0.93
0	0.45
8	0.75
0	0.65
3	0.36
0	0.52
3	0.25
0	0.71
9	0.12
0	0.35
0	0.94
0	0.56
10	0.28
5	0.33
0	0.15
3	0.78
7	0.66
25	0.15
2	0.41
0	0.23
0	0.84
1	0.14
0	0.64

can anyone please help me on that?

Regards,

-Ahmad

[v-qiuyu-msft · Accepted solution]

Hi @Anonymous, 

You can create a measure below: 

Measure = CALCULATE(SUM('Table'[col2]),FILTER('Table','Table'[col1]>0))

Then set visual level filter based on this measure: 

Or you can create a calculated column below: 

Column = IF('Table'[col1]>0,RANKX(FILTER('Table','Table'[col1]>0),'Table'[col2],,ASC),BLANK())

Then set a visual level filter like below: 

Best Regards,
Qiuyun Yu