Forum Discussion
Solved
Rank Returning Blank
Hi all, I must be missing something very simple here... I have 2 tables, One that lists Depots by name and depot number, the second is a list of scores by Depot Name and Number A seperate table has...
villa1980 , Try using the below measure
Rank_Score =
RANKX(
FILTER(
ALLSELECTED(Depot[Depot Name]),
NOT(ISBLANK(Depot[Depot Name]))
),
[Score],
,
DESC,
DENSE
)
villa1980 , Try using the below measure
Rank_Score =
RANKX(
FILTER(
ALLSELECTED(Depot[Depot Name]),
NOT(ISBLANK(Depot[Depot Name]))
),
[Score],
,
DESC,
DENSE
)
Thank-you for the quick reply, unfortunately it has not removed the blank Depot Name, I wonder if there is an issue with my join between the 2 tables and there is a rogue depot that is causing the blank.
