Forum Discussion
bml123
Post Patron
4 years agoShared header for measures in a matrix
Hi, I have a table like this with all the measures in a matrix with lot of calculations in the measures. Employee Measure1 Target Measure1 Actual Measure2 Target Measure2 Actual 1 ...
- 4 years ago
Hi, bml123 ;
You could create a table like below:
Then create a measure .
Measure = SWITCH ( TRUE (), MAX ( [Column1] ) = "Measure1"&& MAX ( [Column2] ) = "Actual", [ActualMeasure1], MAX ( [Column1] ) = "Measure1"&& MAX ( [Column2] ) = "Target", [TargetMeasure1], MAX ( [Column1] ) = "Measure2"&& MAX ( [Column2] ) = "Actual", [ActualMeasure2], [TargetMeasure2])The final output is shown below:
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
bml123
Post Patron
4 years agoamitchandak
Super User
4 years agobml123 , check if this video can help