Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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] ) )
User | Count |
---|---|
124 | |
106 | |
99 | |
63 | |
59 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |