Forum Discussion

Krexx's avatar
Krexx
Helper I
5 years ago
Solved

Create Column Header above Measures in Matrix or delete empty columns

Hello together, i will try it simple 🙂 I would like to achieve this  So now when i am using following code i am losing the measure under the headername "Month" & "YTD", so i cant...
Need Help
  • MFelix's avatar
    MFelix
    5 years ago

    Hi Krexx 

     

    Instead of using a variable use the syntax within the switch measure:

    SWITCH(SELECTEDVALUE(Spalten[ID]),
1, CALCULATE([H_R_Monat]),
2, CALCULATE([H_A_Monat]),
3, CALCULATE([H_Ist_Gesch_M]),
4, CALCULATE([H_P_Monat]),
5, CALCULATE([H_Abw_Monat]),
6, CALCULATE([H_in%_Monat]),
10, CALCULATE([H_R_YTD]),
11, CALCULATE([H_A_YTD]),
12, CALCULATE([H_Ist_Gesch_YTD]),
13, CALCULATE([H_P_YTD]),
14, CALCULATE([H_Abw_YTD]),
15, CALCULATE([H_in%_YTD]),
19, CALCULATE([H_P_Year]),
20, CALCULATE([H_P_Monat])
)

     

     

     

MFelix's avatar
MFelix
Super User
5 years ago

Hi Krexx 

 

Instead of using a variable use the syntax within the switch measure:

SWITCH(SELECTEDVALUE(Spalten[ID]),
1, CALCULATE([H_R_Monat]),
2, CALCULATE([H_A_Monat]),
3, CALCULATE([H_Ist_Gesch_M]),
4, CALCULATE([H_P_Monat]),
5, CALCULATE([H_Abw_Monat]),
6, CALCULATE([H_in%_Monat]),
10, CALCULATE([H_R_YTD]),
11, CALCULATE([H_A_YTD]),
12, CALCULATE([H_Ist_Gesch_YTD]),
13, CALCULATE([H_P_YTD]),
14, CALCULATE([H_Abw_YTD]),
15, CALCULATE([H_in%_YTD]),
19, CALCULATE([H_P_Year]),
20, CALCULATE([H_P_Monat])
)

 

 

 

MFelix's avatar
MFelix
Super User
5 years ago

Hi Krexx  

 

Just for your information this has to do with the context transiction, since you were using the Variable that is calculated before the function you need the context is given before the calculation so you need to have the ID column on the visualization, when you place the ID in within the switch function the table context is first loaded and then the ID is already consider for the calculation so the corresponding rows of each ID appear normally.