Forum Discussion

Pikachu-Power's avatar
Pikachu-Power
Impactful Individual
4 years ago
Solved

split switch true measure

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.
Need Help