Use of Rankx with a previously defined measure - possible?

[lanndestefano]

Hi all, can I use rankx with a previously defined measure? E.g., essentially creating a measure of a measure?

My original measure references a table ("S") and calculates a volume variance by brand versus a previous month ("Measure X"). Now I'd like to rank those variances. Having difficulty - all values are returning as the highest or lowest ranked number (e.g., Brand A=1, Brand B=1, Brand C=1, Brand D=100, Brand E=100, etc.).

What I'm using follows.  Help?

Measure = rankx(all(Table S),Table S[Measure X],,asc)

[Vvelarde]

@lanndestefano please, Post sample data to try to give you a solution

[lanndestefano · Accepted solution]

Thanks @Vvelarde and @Sean. @Sean - that's not quite what I was looking for - but I did figure it out.

Ranking a previously defined measure:

NOT this: = rankx(ALL(table S),table S[measure X],,asc)

SOLUTION: = rankx(ALL(table S),[measure X],,asc)

[Sean]

@lanndestefano Not sure if this is what you are looking for but take a look at this...

http://community.powerbi.com/t5/Desktop/How-to-Rank-a-list-based-on-2-values-double-rankX/m-p/44076#...