Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Preparing for a certification exam? Ask exam experts all your questions on May 15th. Register now.
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 | ||||
2 |
I want to merge the headers like this. How do I achieve that?
Employee | Measure 1 | Measure2 | ||
Target | Actual | Target | Actual | |
1 |
Solved! Go to Solution.
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.
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 , 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])
)
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
78 | |
76 | |
70 | |
49 | |
42 |
User | Count |
---|---|
62 | |
40 | |
32 | |
30 | |
29 |