Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Display rank for current user

I have ranked data in a matrix based on volumes & manager name, that filters based on the financial year selected.     What I want to do on a separate details page, is filter all the results...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Anonymous,

 

Could you try this formula?

ETOU Rank = RANKX(ALLSELECTED(Managers[MANAGER_NAME]),[ETOU GWh Won])

 

Regards,
Yuliana Gu

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Thanks v-yulgu-msft,

I tried that in a measure and calculated table, both returned 1 for all records.

 

I've decided to go another way with this report - so rank isn't going to be used any further.

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi Anonymous,

     

    Thanks for your sharing.

     

    Regards,
    Yuliana Gu