Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I am working on Ranking the table visual rows based on the Redemptions values in Power BI Desktop Report Server. Please help me with a measure to be able to achieve it. Please note RANKX function is not enabled in my Desktop version.
Here is the output I am looking for, doing Row number on zip based on Redemptions count. I appreciate your help. Thank You!
ZIP | Redemptions | Row Number |
336076546 | 30 | 1 |
11355 | 28 | 2 |
10031 | 24 | 3 |
10454 | 22 | 4 |
945504200 | 21 | 5 |
Solved! Go to Solution.
@Anonymous
The following DAX works for me. Upgrade the version and make sure it is a measure, not calculated column.
Measure =
RANKX ( ALLSELECTED ( Query1[ZIP] ), CALCULATE ( SUM ( Query1[Redemptions] ) ) )
Hi,
I'll be unable to help without the RANKX.
@Anonymous
The following DAX works for me. Upgrade the version and make sure it is a measure, not calculated column.
Measure =
RANKX ( ALLSELECTED ( Query1[ZIP] ), CALCULATE ( SUM ( Query1[Redemptions] ) ) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |