DAX Issue & unsure of approach: RANKX, CALCULATE

[P0werB1User]

redacted

[amitchandak]

@P0werB1User 

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale

https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/3...

https://www.sqlbi.com/articles/filtering-the-top-3-products-for-each-category-in-power-bi/

https://www.burningsuit.co.uk/blog/2019/05/find-top-or-bottom-n-percent-dax/

[Greg_Deckler · Accepted solution]

Seems reasonable. Could probably help more if you had sample data as text, sample output and logical explanation of how to get from a to b. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490