Forum Discussion
Dynamic ranking based on a matrix
Hi all, I am rather new to PowerBI and I am trying to get a dynamic ranking. My current data is structured as follows: Trade ID Date Asset Class Broker Trade amount X00001 10.01.2019 ...
amitchandak
Super User
Super Userthaller ,
rankx(allselected(Table[Broker]), calculate(Sum(Table[amount])))
rankx(filter(allselected(Table[Broker],table[Year]), [Year] =max([Year])), calculate(Sum(Table[amount])))
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/367415