Forum Discussion
Help with Rank on Measure
Hi - Please help with Ranking in attached pbix..
Ranking is supposed to be: for each SKU by MFG
https://www.dropbox.com/s/8q0d95e5edp5wze/Sample_PBI.pbix?dl=0
TIA
4 Replies
Something similar to this one
Rank2 = RANKX( filter(ALL(samplesuperstore[Country],samplesuperstore[City]),samplesuperstore[Country]=max(samplesuperstore[Country])),CALCULATE(sum(samplesuperstore[Profit])),,ASC,Skip)Thanks,Riteshribisht17
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?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
All_In_One_Aug_22 - Google Drive > Look for the page with a name as RANKX , there are multiple pages there
