Forum Discussion
dynamic Ranking, in a Model with two fact tables and a calculated measures table
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
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=25627s
Power BI Rank Across dimension tables: https://youtu.be/X59qp5gfQoA
Power BI - New DAX Function: RANK - How It Differs from RANKX: https://youtu.be/TjGkF44VtDo
Well I hat to clean my Data Model. Now it works. Thank you