Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I'm trying to rank locations based on a dynamic Top N filter using parameters. It seems to work if I have only loc2_name in my table view but when I add the location&state field as well to the view the ranks are shown as 1 . Can anyone help me on what I'm missing here.
Solved! Go to Solution.
Hi @DPJay
As tested, when all columns added to the Table visual is set as "don't summarize", create a measure as below may works
Note: compare with yours, please pay attention to the bold character.
Measure = IF(HASONEVALUE(Table1[late]), RANKX(ALL(Table1),[value],,DESC))
Best Regards
Maggie
Hi @DPJay
As tested, when all columns added to the Table visual is set as "don't summarize", create a measure as below may works
Note: compare with yours, please pay attention to the bold character.
Measure = IF(HASONEVALUE(Table1[late]), RANKX(ALL(Table1),[value],,DESC))
Best Regards
Maggie
Hello,
Rank Measure = IF ( HASONEVALUE ( FINAL_TBL[location&state] ), RANKX ( ALL (FINAL_TBL[location&state]), [TOT_QTY] ) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |