Forum Discussion

villa1980's avatar
villa1980
Resolver II
1 year ago
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...
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    1 year ago

    villa1980 , Try using the below measure

     

    Rank_Score =
    RANKX(
    FILTER(
    ALLSELECTED(Depot[Depot Name]),
    NOT(ISBLANK(Depot[Depot Name]))
    ),
    [Score],
    ,
    DESC,
    DENSE
    )

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi villa1980 ,

 

First thanks for the quick reply from bhanu_gautam , I have some other thoughts to add:

Please try using the below measure:

Rank_Score =
RANKX(
FILTER(
ALLSELECTED(Depot[Depot Name]),
Depot[Depot Name]<>BLANK()
),
[Score],
,
DESC,
DENSE
)

If that doesn't work, please provide some example data and table relationships (to protect your private data).

 

Best Regards,

Neeko Tang

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