Forum Discussion
Display rank for current user
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.
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])
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?
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
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