Forum Discussion

bml123's avatar
bml123
Icon for Post Patron rankPost Patron
4 years ago
Solved

Shared 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 ...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    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.

     

v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
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.