Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I've got a pretty simple model, so I can't figure out why this isn't working for me...
The screen shots pretty much explain the issue. Trying to rank based on the [NumFolios] calculated measure.
There are slicers on the page, hence the ALLSELECTED. There are FILTERs applied as well... no blank zips.
Ultimately the OTA table will need to be excluded from the results, but I'm handling this in a filter right now as well.
[NumFolios] is a raw number coming through in a SQL query
Solved! Go to Solution.
Thanks for the pointers gang. I ended up taking a slightly different approach.
Since the demograph table has 1 row per zip, I figured that was a good spot to put the ranking.
I first created a Calculated Measure in that table...
ZipTotalFolios = SUMX(RELATEDTABLE(GuestProfile), GuestProfile[NumFolios])
Then, I was able to rank on that, IN the demograph table again, using this...
demoRanker = RANKX(ALLSELECTED(Demograph), [ZipTotalFolios])
So far it's doing what I want, but I wish I understood what was causing the bad rankings before.
Thanks for the pointers gang. I ended up taking a slightly different approach.
Since the demograph table has 1 row per zip, I figured that was a good spot to put the ranking.
I first created a Calculated Measure in that table...
ZipTotalFolios = SUMX(RELATEDTABLE(GuestProfile), GuestProfile[NumFolios])
Then, I was able to rank on that, IN the demograph table again, using this...
demoRanker = RANKX(ALLSELECTED(Demograph), [ZipTotalFolios])
So far it's doing what I want, but I wish I understood what was causing the bad rankings before.
Hi @gjohnson900
When I use your dataset to apply the measure formula, I get this result. Does it meet your goal?
I wonder which columns add to slicers and filters and whether any other formula quotes the rank measure.
Best Regards
Maggie
Hi @gjohnson900
How do you get on with this slightly different version
Ranker = RANKX( ALL('GuestProfile'[Zip]) , CALCULATE( SUM('GuestProfile'[NumFolios]) ) )
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
91 | |
81 | |
65 | |
65 | |
60 |
User | Count |
---|---|
170 | |
114 | |
102 | |
73 | |
69 |