Forum Discussion

I_Like_Pi's avatar
I_Like_Pi
Icon for Resolver II rankResolver 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
GilesWalker's avatar
GilesWalker
Icon for Skilled Sharer rankSkilled Sharer
10 years ago

Are you able to provide an example of the data?

 

ALeef response sounds about right except you could use SUMX(SUMMARIZE(...)) This creates a distinct table (C_address) and then calculates all the Hours_SUM for each distinct value (C_Address).

 

Going off of your information the formula would look like this - Aggregated totals = SUMX(SUMMARIZE(Table Name,[C_Adress],[C_Gross]),[C_Gross])

 

Change Table Name to the name of your table.

 

Giles