Creating a Top N Measure with Filters

[Mighaz]

Hello Everyone,

I am newbie at PowerBI and stuck at an issue. I have a huge dataset of sales at outlet level. 

I have the following list of columns in my data: Year, Month, Outlet Number, City, Store Type, Sales Developer Name, Area Sales Manager Name, Category (Juice, water etc.), Brand, Package Group (Plastics, steel etc.), Package size (500 ML, 1000 ML etc.)

My end target is to create a measure titled "Top 10%-2017' which would return sales from top 10% of the outlets. Ideal output should look something like this for the selection of city wise sales:

The criteria for Top 10% outlets is the following:

All outlets should be ranked based on their overall sales for the full year 2017, but should return sales for whatever metric is selected. For instance if I want to see what are the sales of 500 ML packs in the Top 10% outlets then I should be able to do that via this measure.

Any help would be very much appreciated.

Thanks in advance.

[v-chuncz-msft · Accepted solution]

@Mighaz,

You may learn to use RANKX Function.

https://www.sqlbi.com/articles/use-of-rankx-in-power-bi-measures/