cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RenataOGardner
Helper I
Helper I

RANK measure help.

Hi everyone,

 

My measure rank is using the grand total values as well, which is wrong. How can still have the grand total and not be ranked?

The measure I'm using for rank the products is:

SKU Rank = RANKX(ALL('Item'),[AB_Sell Out Units])

 

RenataOGardner_0-1619254119766.png

 

And below is missing the 3rd product. and ranking again the grand total.

 

RenataOGardner_0-1619254466482.png

 

 

Many thanks!

 

2 ACCEPTED SOLUTIONS
daxer-almighty
Solution Sage
Solution Sage
Greg_Deckler
Super User IV
Super User IV

@RenataOGardner - https://community.powerbi.com/t5/Quick-Measures-Gallery/To-Bleep-with-RANKX/m-p/1042520#M452

 


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

2 REPLIES 2
Greg_Deckler
Super User IV
Super User IV

@RenataOGardner - https://community.powerbi.com/t5/Quick-Measures-Gallery/To-Bleep-with-RANKX/m-p/1042520#M452

 


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

daxer-almighty
Solution Sage
Solution Sage

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors