Forum Discussion
RANKX
I have a Email Interactions table which is at Interaction_ID and SDR_NAME(Sales rep name) level. I want to rank them based on a score (A measure), I'm using the below formula, using ALL() for the ran...
ValtteriN
Community Champion
Community ChampionHi,
It is likely that your expression is returning unexpected values during eavulation. So try creating measure Also ALL is not as good with RANKX as ALLSELECTED so try using it.
Generally speaking RANKX is pretty forgiving in my mind so the issue is usually in the expression part of the measure.
Example:
Here I have 3 different RANX measures:
Ranking simple = RANKX(ALLSELECTED(Ranking),Ranking[Average metric])
Ranking simple all = RANKX(ALL(Ranking),Ranking[Average metric])
Ranking simple all EID + desc + dense = RANKX(ALL(Ranking[EID]),Ranking[Average metric],,DESC,Dense)
In a table they look like this:
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
In a table they look like this:
Only the second measure is behaving weirdly this is due the ALL's interaction with Year + Month Slicer. When all values are displayed the issue is gone:
So in short, try using ALLSELECTED instead of ALL and double check your expression part of the measure.
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/