topic rank based on only a single dimension even if it has multiple dimension in DAX Commands and Tips

rank based on only a single dimension even if it has multiple dimension

Anonymous — Fri, 24 May 2024 05:56:42 GMT

Hi Team,

I have to below table structure.

Plaform Tier Sales Rank Required rank
B BB 2178 1 1
I BB 2207 2 2
H CC 2258 3 3
A AA 2362 4 4
F LL 2416 5 5
D LL 2530 5 6
E LL 2782 5 7
C AA 2840 6 8
J DD 2907 6 9
G AA 3002 7 10

I have written a measure like this

RANKX(ALLSELECTED('platform view'[platform]),CALCULATE(SUM('platform view'[sales])))

It is returning the correct result on Plarform level but when I pull Tier, ranking is wrong. Tier is coming from same table as platform.

Please guide me. what should I do so that when I pull tier in visual then ranking shouldn't get disturbed?

amitchandak

Re: rank based on only a single dimension even if it has multiple dimension

bhanu_gautam — Fri, 24 May 2024 07:35:14 GMT

Anonymous ,

You need to modify your measure to include the Tier column in the RANKX function.

RANKX(ALLSELECTED('platform view'[platform], 'platform view'[Tier]), CALCULATE(SUM('platform view'[sales])))

Re: rank based on only a single dimension even if it has multiple dimension

Anonymous — Mon, 27 May 2024 10:39:49 GMT

bhanu_gautam Thank you for reply but this way it isn't working I have tried using it already

Re: rank based on only a single dimension even if it has multiple dimension

Anonymous — Tue, 28 May 2024 01:00:29 GMT

Hi Anonymous ,

First of all, many thanks to bhanu_gautam for your very quick and effective replies.

Based on my testing, please try the following methods:

1.Create the simple table.

2.Create the new measure to rank based on platform.

PlatformRank = RANKX( ALL('platform view'[Plaform]), CALCULATE( SUM('platform view'[Sales]), ALLEXCEPT('platform view', 'platform view'[Plaform]) ), ,ASC )

3.Drag the new measure into the table visual.

4.The result is shown below.

Best Regards,

Wisdom Wu

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