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
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Not at all, I've put a financial year slicer on the details page as well, so the managers can see how they did in years past

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

Hi Anonymous

 

One idea is to create a calcuated table in with data aggregated to just what you need and add the [ETOU GWh Won] and [Rank] formulas as calcuated columns on the calcuated table

    • v-yulgu-msft's avatar
      v-yulgu-msft
      Microsoft 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.