Doing Row Number or Rankx on Power BI Direcy Query

[Anonymous]

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

[Ashish_Mathur]

Hi,

I'll be unable to help without the RANKX.

[v-chuncz-msft · Accepted 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] ) ) )

[Anonymous]

@Ashish_Mathur/ @OwenAuger  would you be able to help me with this, please?