cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shebashalinim Frequent Visitor
Frequent Visitor

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!

 

 ZIPRedemptionsRow Number
336076546301
11355282
10031243
10454224
945504200215
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Doing Row Number or Rankx on Power BI Direcy Query

@shebashalinim 

 

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] ) ) )

 

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Highlighted
shebashalinim Frequent Visitor
Frequent Visitor

Re: Doing Row Number or Rankx on Power BI Direcy Query

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

Community Support Team
Community Support Team

Re: Doing Row Number or Rankx on Power BI Direcy Query

@shebashalinim 

 

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] ) ) )

 

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Super User IV
Super User IV

Re: Doing Row Number or Rankx on Power BI Direcy Query

Hi,

I'll be unable to help without the RANKX.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors