RANKX Problem

Question

I have a problem with the Rankx all stores &amp; RKS column.I want it to show the ranking of a given store within all RKS.To sum up: the Rankx all stores column shows a dynamic ranking depending on which country and RKS you choose - it works properly.The Rankx all stores &amp; RKS column should show a dynamic ranking depending on which country you choose, but it should not work with the RKS filter - it should show a total ranking in all RKS.Code column rankx all stores &amp; RKS:&nbsp;Rankx all stores &amp; RKS = RANKX(
ALL(DimLocalization[RKS];DimLocalization[StoreID]);
CALCULATE(SUM(FactSales[Revenue_Net]))&nbsp;&nbsp;

kentyler · Answer

This sounds like a place for ALLEXCEPT()
&nbsp;
CALCULATE(SUM(FactSales[Revenue_Net]))
CALCULATE(SUM(FactSales[REvenue_Net]),ALLEXCEPT(RKS))&nbsp;

amitchandak · Answer

For Rank Refer these linkshttps://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measureshttps://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columnshttps://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale

krzysztof · Answer

amitchandak&nbsp;Unfortunately, I have an exposed cube and can't create columns&nbsp;

amitchandak · Answer

I think I did not suggest any column. All these articles talk about various kinds of ranks. Can you please create some sample data and share with expected output

Forum Discussion

RANKX Problem

4 Replies

Related content

RankX problems

Problem with RANKX

RankX

Logic problem?

Slider problems