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

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

    • 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