Using RANKX and ALL but need to filter out values

[shaebert]

I found this Dax from https://community.powerbi.com/t5/Desktop/display-Rank-on-a-Card-visualization/m-p/168064

OVERALL_RANK = RANKX(
		ALL(Sales[Store]);
		CALCULATE(
			SUM(Sales[Sales])
			 )
		    )

To help with my challenge. I was able to edit it to this: 

OVERALL_RANK = RANKX(
		ALL(MasterTable[Campaign Location]),
		CALCULATE(
			[Opps Created])
			 )
		    )

 This spits out the following:

This is great, but I don't want to include Admin, HBS, and Unknown row. IL should be 1, IA should be 2, etc. 

Does anyone know what I can do to edit the Dax to get the result I am looking for?

[shaebert · Accepted solution]

I figured this out with a work around. For the "Opps Created" measure, I created a new measure that had a calculated filter, filtering out the values I didn't want to include in the RANKX. 

[amitchandak]

@shaebert , I am assuming this a measure rank and Opps Created is a measure

Have tried allselected?

OVERALL_RANK = RANKX(
ALLSELECTED(MasterTable[Campaign Location]),
CALCULATE(
[Opps Created])
)

[shaebert]

Yes, I tried that, but it won't work, because I forgot to mention that I am trying to visualize just one of the regions and their ranking in a card visual.