RANKX -- beginner trouble. Won't rank properly using ALLSELECTED. pics attached

[gjohnson900]

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

[gjohnson900 · Accepted 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.

[v-juanli-msft]

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

[Phil_Seamark]

Hi @gjohnson900

How do you get on with this slightly different version

Ranker = 
	RANKX(
		ALL('GuestProfile'[Zip]) ,
		CALCULATE(
			SUM('GuestProfile'[NumFolios])
			)
	)