Excluding Top N% of values from calculated column

[rjafri2015]

Hi,

I am looking for a way to exclude the top 10% and bottom top 10% of values by category for a calculated column. 

Here is some sample data.

The "Regional CY MTD" and "Regional LY MTD" columns are the sum of CY MTD and LY MTD for all customers in those respective regions. Here is the code for the calcuation. 

Regional CY MTD = CALCULATE(SUM('Table '[Revenue]), DATESMTD('Table - Calendar'[Date]), ALLEXCEPT('Table ','Table'[Sales Region Name]))

What I would like to do is to exclude the top 10% and bottom 10% of accounts based on the "YoY MTD Diff" column when calculating Regional CY MTD and Regional LY MTD. 

[TheoC]

Hi @rjafri2015 

I believe you should be able to achieve what you want using RANKX along with some other measures.  Here is a great article that describes the steps in achieving hoepfully what you are after: https://www.burningsuit.co.uk/find-top-or-bottom-n-percent-dax/

Hope this helps!

Theo