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.
