Forum Discussion
Solved
RANK and RANKX when the fact table is filtered by multiple dimensions
Does anyone have experience using the RANK and RANKX DAX functions when filtering across tables? A client wanting to display a list of organisations ranked by a variety of KPIs where the ranking need...
TonyEv6 , When you add any other column in the visual that is not part of Rank/Rankx, the rank will redistributed or partitioned by the additional column
Refer: Impact of extra visual column on RankX| Why Rank 1 when added city id - https://youtu.be/t77bd57IVqk
Power BI - New DAX Function: RANK - How It Differs from RANKX: https://youtu.be/TjGkF44VtDoAssume you create a Rank
City Rank = RANKX(all(Geography[City]),[Sales])
and add city ID to visual i will give 1 for rank
Thanks. That makes sense.