Forum Discussion
Solved
dynamic Ranking, in a Model with two fact tables and a calculated measures table
Hi everyone, I really need some help with my ranking. I have two fact tables with each offering the base KPI, a calculated Measures Table where I tried to do that dynamic Ranking and other KPI Measu...
AnnKey ,
The measure should be
Divide([Contracts_actual], [Customer_actual])
Rank can be
Rankx(allselected(Table[Stores]), [Contract_ratio])
Measure Rank: https://www.youtube.com/watch?v=DZb_6j6WuZ0&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=40
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=25627sPower BI Rank Across dimension tables: https://youtu.be/X59qp5gfQoA
Power BI - New DAX Function: RANK - How It Differs from RANKX: https://youtu.be/TjGkF44VtDo
Ashish_Mathur
Super User
Super UserHi,
Share the download link of the PBI file and show the expected result there very clearly.