Rank/RankX For Multiple Columns With Repeating Values

Hi waltmiller 

You can refer to the follwing solution.

Sample data 

For the requirement you have offered, you can create two measures.

Rank_org = RANKX(ALLSELECTED('Table'[Org]),CALCULATE(SUM('Table'[Funding])),,DESC,Dense)

Rank_dept = RANKX(ALLSELECTED('Table'[Dept]),CALCULATE(SUM('Table'[Funding])),,DESC,Dense)

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you, Yolo Zhu. That's close to what I've been trying, but every time I do this, all ranks are returned as 1:

Any ideas? Is it a data type issue in my source data?