split switch true measure

[Pikachu-Power]

Hello all,

I have an extensive SWITCH TRUE Measure like following simple example: 

SWITCH(TRUE,

SELECTEDVALUE(Table[Row]) = "A", Measure1,

SELECTEDVALUE(Table[Row]) = "B", Measure2,

SELECTEDVALUE(Table[Row]) = "C", Measure3,

SELECTEDVALUE(Table[Row]) = "D", Measure4,

SELECTEDVALUE(Table[Row]) = "E", Measure5

SELECTEDVALUE(Table[Row]) = "F", Measure6,

SELECTEDVALUE(Table[Row]) = "G", Measure1 + Measure 2 + Measure 3 + Measure4 + Measure 5 + Mesaure 6,

and so on

Now I want filter Measure2 until Measure6 like 

IF(SELECTEDCALCULATE(Table2[Row]) = "X", CALCULATE(Measure1, Table[Row2] = "X"), CALCULATE(Measure1, Table[Row2] = "Y"))

But Measure1 stays untouched.

It would be a lot of work to go through every measure in this way... is there a way to do it more compact/easy?

Maybe there is a way to split the SWITCH TRUE Measure in two parts? One with Measure1 and one with Measure2 to Measure6. Then the IF(SELECTEDVALUE(... part could be applied to the whole second SWITCH TRUE Measure.

Many thanks for ideas.

[amitchandak · Accepted solution]

@Pikachu-Power , try calculation groups

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0