Forum Discussion
RANKX Issues, been trying everything
I've had a series of issues using RANKX...after many issues I just built a new table. Now I'm running into the following: The table contains Date, Store Name, Region, Agent ID, Agent Name, and ...
Fowmy
Super User
Super UserAnonymous
Do you have relationship between AgentTable and Revenue table? create the relationship if it's not there. You should be able to add all the fileds if necessary, it will work
Rank = RANKX(ALLSELECTED('AgentTable'),CALCULATE(sum('Revenue '[RevenueSum])),,,Skip)