Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
bml123
Post Patron
Post Patron

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    

 

 

 

1 ACCEPTED SOLUTION
v-yalanwu-msft
Community Support
Community Support

Hi, @bml123 ;

You could create a table like below:

vyalanwumsft_0-1645766513637.png

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:

vyalanwumsft_1-1645766604512.png


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.

 

View solution in original post

4 REPLIES 4
v-yalanwu-msft
Community Support
Community Support

Hi, @bml123 ;

You could create a table like below:

vyalanwumsft_0-1645766513637.png

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:

vyalanwumsft_1-1645766604512.png


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
Super User
Super User

@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])
)

Hi @amitchandak 

 

Can you please let me know how to do with calculation group

 

@bml123 , check if this video can help

https://youtu.be/qMNv67P8Go0

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.