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
ALeef's avatar
ALeef
Icon for Resolver II rankResolver II
10 years ago

Can I get a little more explanation on what you are looking for?  To me it sounds like a service business - IE House calls for fixing air conditioners or something, and you are looking to take a list of all the visits, sum them for total hours spent there, and then order them based on those hours.  Is that correct?

 

If so, I'd use a caclulated table that pulls DISTINCT addresses in, and then a SUMX of hours for that address.  I'm not at my work machine so I can't test it out, sorry.