Rank to be given

[Anonymous]

I have this data how can I provide them rank.

Store Name	SUM(CALLS_SUM)
AD	12,741
ADM	14,507
AE	990
AEDU	201
AEM	4,395
AEMD	2,297
AF	36
AFME	2
AFMO	13
AFMW	9
AG	5
AGM	33
AGMD	23
AIMD	3
AIMF	2
AK	35
AL	82
ALMA	218
ALME	56
ALMV	854
AM	10
AMGG	1
AMGU	2

[danielkrol]

Wow, Thats a bit descriptive...

Might be something like this?

RANK =

VAR _call_sum = Blad1[SUM(CALLS_SUM)]

return

CALCULATE(COUNT(Blad1[Store Name])+1, FILTER(ALL(Blad1), Blad1[SUM(CALLS_SUM)] > _call_sum))

[Anonymous · Accepted solution]

Thanks... finally able to figure it myself... used this

Rank = rankx(ALLSELECTED(Sheet2[PRICE_NAME]),CALCULATE(sum(Sheet2[SUM(CALLS_SUM)])),,desc,dense)