Forum Discussion
Doing Row Number or Rankx on Power BI Direcy Query
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 |
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] ) ) )
3 Replies
Ashish_Mathur/ OwenAuger would you be able to help me with this, please?
v-chuncz-msftCommunity Support
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] ) ) )- Ashish_Mathur
Super User
Hi,
I'll be unable to help without the RANKX.
