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
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?

      • 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