Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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])
)
@bml123 , check if this video can help
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
109 | |
89 | |
76 | |
66 |
User | Count |
---|---|
125 | |
111 | |
100 | |
83 | |
71 |