Ranking game sales by month

[RogerSteinberg]

Hi,

I was able to rank sales by various dimensions on a daily basis but wasn't able to incorporate the monthly ranking into my measure:

RANKX( 
    ALLSELECTED( 'Table'), // Need to keep allselected so that ranking applies to other attributes
    [Revenue Sales], // Measure
    , DESC, Dense 
    )
    

[v-lionel-msft]

Hi @RogerSteinberg ,

Please give a copy of the sample data and the formula for the measure [Revenue Sales].

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Tahreem24]

Try the measure:

RankColumn = RANKX(FILTER(Table,Table[Month]=EARLIER(Table[Month])),RevenueMeasure,,DESC, Dense)

[RogerSteinberg]

By doing so , you remove the allselected logic which is crucial when I need to rank  games by sales . I also have slicers .

[Tahreem24]

Use this:

RankColumn = RANKX(FILTER(ALLSELECTED(Table),Table[Month]=EARLIER(Table[Month])),RevenueMeasure,,DESC, Dense)

[RogerSteinberg]

it gives me the same value. its not working