Rank Calculated Column

[powerbiwork]

Hi All, 

I'm trying to get a ranking with a calculated column but it is not working for some reason. Any help on it will be greatly appreciated.

Thanks. 

It is pulling two objects from SalesForce, Account (Name and Region) and Opportunity (signed deals) Object. The calculated column (

Signed Deals = CALCULATE(CALCULATE(COUNTA(Opportunity[StageName]),SEARCH("6",Opportunity[StageName],,0)))) is the Signed Deals column which I had summed. I'm trying to rank (

RankCY = RANKX(ALLSELECTED(Account),CALCULATE(SUM(Opportunity[Signed Deals]))))

the signed deals but it's not coming out how I'd imagine to be.

[pranit828 · Accepted solution]

Hi @powerbiwork 

I would give the below code a try

RANKX(ALLSELECTED(Account),CALCULATE(SUM(Opportunity[Signed Deals])),,,dense)

[powerbiwork]

Works awesome! Thanks so much!