Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I have the following Data loaded into Power BI.
Country | Currency | Value |
Australia | USD | 100 |
Singapore | SGD | 90 |
Malaysia | USD | 80 |
NZ | NZD | 70 |
Australia | AUD | 60 |
Malaysia | MYR | 50 |
Australia | AZD | 60 |
I want to display Top 3 Country by Value in desc order. I have applied Top N filter condition as shown below but I am not getting the desired result. This is because in Country Column, Australia and Malaysia values are repeated due to different Currency column. Is there a way to get only the Top 3 rows? Thanks.
Solved! Go to Solution.
you can create two measures
_value = sum('Table'[Value])
Measure = RANKX(all('Table'),[_value],,DESC)
and add measure to the filter
Proud to be a Super User!
you can create two measures
_value = sum('Table'[Value])
Measure = RANKX(all('Table'),[_value],,DESC)
and add measure to the filter
Proud to be a Super User!
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |