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 to the current manager, by using the USERNAME() formula. The other measures i'm using work fine with this additional filter. The RANK, however, i've been unable to figure out, without using a slicer.

 

Based on the table above, viewing the details page as Steven, I want to see the rank of 4 for the ETOU GWh - every variation i've tried so far as returned 1 - presumably because it's filtering the entire dataset to Just Steven.

 

Need Help

9 Replies

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    9 years ago

    Hi Anonymous

     

    Do you carry the information about the financial year selected through to your details page?  I think this will be needed to re-work out on your details page what Stevens ranking should be.

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi Phil_Seamark

       

      No, it's not - the financial year is selected via slicers.. is it possible to carry that across pages?

       

      I have a measure calculate what the selected financial year is, which is used in other measures to filter the data.

       

      The etou gwh won measure calculation is this:

      ETOU GWh Won = CALCULATE(SUM(WIP_Data[TOU Volume]),
			FILTER('WIP_DATA',WIP_Data[Outcome]="Won"),
			FILTER(ALL(Dates),Dates[FINANCIAL_YR]=MAX(Dates[FINANCIAL_YR])),
			FILTER(WIP_Data,WIP_Data[Fuel ]="Elec"))+0

       

      This is the current Rank measure:

      ETOU Rank = RANKX(ALL(Managers[MANAGER_NAME]),[ETOU GWh Won])
      • Phil_Seamark's avatar
        Phil_Seamark
        Microsoft Employee
        9 years ago

        Hi Anonymous

         

        Slicers can only filter visuals on the same report page as the slicer.  They have no effect on other pages.  Will that be a problem?