Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
spartanboy
Helper II
Helper II

Help with Rank on Measure

Hi - Please help with Ranking in attached pbix..
 Ranking is supposed to be: for each SKU by MFG

spartanboy_0-1660056887288.png

https://www.dropbox.com/s/8q0d95e5edp5wze/Sample_PBI.pbix?dl=0

 

TIA

 

4 REPLIES 4
ribisht17
Super User
Super User

ribisht17_0-1660104753933.png

All_In_One_Aug_22 - Google Drive > Look for the page with a name as RANKX , there are multiple pages there

ribisht17
Super User
Super User

@spartanboy 

 

Something similar to this one 


Rank2 = RANKX( filter(ALL(samplesuperstore[Country],samplesuperstore[City]),samplesuperstore[Country]=max(samplesuperstore[Country])),CALCULATE(sum(samplesuperstore[Profit])),,ASC,Skip)
 
ribisht17_0-1660059862794.png

 

 
Thanks,
Ritesh

@ribisht17 
Matching my example with yours.

I have a slicer with Continent, if i choose any single continent then ranking should be only for corresponding countries. The above DAX yields with 1 for all the continents/country/city.

Can you provide a pbix workbook with your example please?

@ribisht17 

 

Thanks for the update. How can i not RANK "Supplier 1" in the attached file?

https://www.dropbox.com/s/8q0d95e5edp5wze/Sample_PBI.pbix?dl=0

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.