Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
109 | |
102 | |
84 | |
79 | |
70 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |