How to find rank difference from top account and the normal accounts

[arvindyadav]

Hi Team,

I have created a measure for rank position i.e, 

Rank =

RANKX ( ALL ( Table1[Accounts]), [Profit] ).

Now I want the difference between the top Account and the normal Accounts. how the rank differs from top position to any other account. .ie,

Accounts	Profit	Rank	Difference From top Rank
A	4030	2	1
B	3424	4	3
C	4348	1	0
D	1087	7	6
E	2070	6	5
F	2702	5	4
G	3696	3	2

So basically I want new column as the difference from top Rank in power bi So How to do that please help me out.

Thanks,

Arvind

[LivioLanzo · Accepted solution]

Hi @arvindyadav 

can't you just do the result of your RANKX and subtract one?

[arvindyadav]

Hi @LivioLanzo ,

Thanks. It is quite easy dax formula I did not think about it.

[arvindyadav]

Hey @LivioLanzo ,

Actually, I want a difference in profit.

Accounts	Profit	Rank	Difference From top Rank	Diff in Profit
A	4030	2	1	0
B	3424	4	3	-606
C	4348	1	0	318
D	1087	7	6	-2943
E	2070	6	5	-1960
F	2702	5	4	-1328
G	3696	3	2	-334

That actually means if I click on any account in the slicer it will reflect my difference of that account with the top account.

Thanks,

Arvind

[LivioLanzo]

Hi @arvindyadav  - should not the results be as per my image above?

[arvindyadav]

Hi @LivioLanzo ,

I need answer what you have sent in the image.

[arvindyadav]

Hi @LivioLanzo ,

Good Afternoon!!!

Any Update on this?

Thanks,

Arvind

[LivioLanzo]

@arvindyadav 

try:

Measure = 
var max_profit = MAXX( ALL( Data[Accounts] ), CALCULATE( SUM( Data[Profit] ) ) )
return SUM( Data[Profit] ) - max_profit

[arvindyadav]

sorry,

yup, I need to answer what you have mentioned in that image.

[arvindyadav]

Hi @LivioLanzo ,

Have you got any solution for it?