Forum Discussion
Solved
Create table with measures as values
Hi All Happy new year. I have searched the community for this issue, but I am not finding anything to help. I have a table (matrix) that looks like this: That I need in the table forma...
Hi sthandiwe ,
For this you need to create two tables:
- Component
- Type of measure
Then using a SWTICH function you must add the measures you need to the calculation something similar to:
Metric by component = SWITCH( TRUE(), SELECTEDVALUE(Component[Table]) = "Fi" && SELECTEDVALUE(MeasureType[Column]) = "Budget",MIN(BW[FIBudget]), SELECTEDVALUE(Component[Table]) = "Fx" && SELECTEDVALUE(MeasureType[Column]) = "Budget",MIN(BW[FxBudget]), ... )Then just make the necessary adjustments for each of your metrics
Hi sthandiwe ,
For this you need to create two tables:
- Component
- Type of measure
Then using a SWTICH function you must add the measures you need to the calculation something similar to:
Metric by component =
SWITCH( TRUE(),
SELECTEDVALUE(Component[Table]) = "Fi" && SELECTEDVALUE(MeasureType[Column]) = "Budget",MIN(BW[FIBudget]),
SELECTEDVALUE(Component[Table]) = "Fx" && SELECTEDVALUE(MeasureType[Column]) = "Budget",MIN(BW[FxBudget]),
...
)
Then just make the necessary adjustments for each of your metrics
