Forum Discussion

I_Like_Pi's avatar
I_Like_Pi
Resolver II
10 years ago

Using DAX RANKX to rank Aggregated totals (Newb)

I hope I've found the right forum, if this is the wrong place for this and you know of a place to go for such please reply with that. I'm a total newb to this and cant find any decent forums for DAX/...
Need Help
tanckc's avatar
tanckc
Regular Visitor
10 years ago

Did you ever get an answer? I have the same issue

jahida's avatar
jahida
Impactful Individual
10 years ago

Wasn't involved in the initial discussion but this looked fun so I gave it a stab, here's the formula I used:

 

Rank = SELECTCOLUMNS(FILTER(SELECTCOLUMNS(
					SUMMARIZE(ALL(Table1), Table1[C_Address], "C_Gross", SUM(Table1[C_Gross])),
					"Address", Table1[C_Address], "Rank",
											RANKX(SUMMARIZE(ALL(Table1), Table1[C_Address], "C_Gross", SUM(Table1[C_Gross])), [C_Gross])),
					[Address] = Table1[C_Address]), "r", [Rank])

Very messy but it did give the expected result (I think):