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

[Anonymous]

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 

[Anonymous · Accepted solution]

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.

[Anonymous]

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

[bhanu_gautam]

@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])))