RANKX and muliple slicers

[andersrisann]

Hi,

I have a set of stores with revenue per week/year. Each store has a ID, belongs to a revenue group and price class. I want to rank the stores by the revenue growth compared to a time period previous year.

        

I have created a measure that calculates the %-revenue growth as follows (and it's working), but have some issues with the ranking.

I have tried using this measure without any luck:

Rank rev_growth_ALL = 

        RANKX(

        FILTER(ALL(Store_ID),

        dStores[Revenue Group]=SELECTEDVALUE(dStores[Revenue Group])&&

        dStores[Price class]=SELECTEDVALUE(dStores[Price class])),

        [revenue_growth]))

The issue is that I have three slicers for the Store ID, Revenue group and Price class respectivly. If I filter on a specific store without selecting any of the other slicers, I want to return the rank of the selected store relative to all stores within the same revenue group and price class. This is manged by my above DAX code.

HOWEVER, if I select a revenue group without selecting any stores, my stores are ranked per price class, while I want it to show the rank for all stores within that revenue group disregarding the price classes. 

Thus, it's the different combinations of my slicers which creates some issues with the ranking. 

Any idea on how to solve this?

[v-binbinyu-msft]

Hi @andersrisann ,

I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting and desensitized example data.

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_Binbin Yu