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.

 

EmployeeMeasure1 TargetMeasure1 ActualMeasure2 TargetMeasure2 Actual
1    
2    

 

 

I want to merge the headers like this.  How do I achieve that?

EmployeeMeasure 1 Measure2 
 TargetActualTargetActual
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.

     

4 Replies

  • 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.

     

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    bml123 , This is a measure to measure and dimension conversion. You can try calculation group

     

    Or You have to create a new table like an example and use that. Bring all the filters as a group  by as this a new table

     

    Try

     

    union(
    summarize('Table',"Measure","sales","This period",[SALES YTD],"Last period",[SALES LYTD],"POP",[SALES YOY])
    summarize('Table',"Measure","unit","This period",[unit YTD],"Last period",[unit LYTD],"POP",[unit YOY])
    )

     

     

    or

     

    union(
    summarize('Table','Table'[country],"Revenue","sales","This period",[Revenue YTD],"Last period",[Revenue LYTD],"POP",[Revenue YOY])
    summarize('Table','Table'[country],"Costs","unit","This period",[Costs YTD],"Last period",[Costs LYTD],"POP",[Costs YOY])
    )