Help with Rank on Measure

[spartanboy]

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

[ribisht17]

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

[ribisht17]

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

Thanks,

Ritesh

[spartanboy]

@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?

[spartanboy]

@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