Matrix showing actual vs budget

[Matteoss]

Hello dears, 

I have to replicate the table attached below in Power BI and I have found some issues. 

On the rows, there are periods (months) on the columns the economic indicators. 

The problem is to show the actual (CST)  and the BDG values on the rows and not on the columns. 

Thanks in advance for your help!

Matrix to replicate in power BI

[amitchandak]

@Matteoss , seem like breaking of measure into dimension and measure.

You have take help of union and summarize, need to include all group by or filter

example

union(
summarize('Table','Table'[Version_Id],"Var","Variable 1", "Sum",sum('Table'[variable 1]), "Count",count('Table'[variable 1])),
summarize('Table','Table'[Version_Id],"Var","Variable 2", "Sum",sum('Table'[variable 2]), "Count",count('Table'[variable 2]))
)

or

union(
summarize('Table','Table'[Type],"Measure","Qty", "Budget",[Budget], "Sold",[Sold], "diff",[diff]",diff %",[dif%]),
summarize('Table','Table'[Type],"Measure","Amnt", "Budget",[Budget], "Sold",[Sold], "diff",[diff]",diff %",[dif%])
)

or

union(
summarize('Table',"Measure","Sales Growth", "ACT",[Sales Growth], "PY",[Sales Growth PY], "FC",[Sales Growth FC]),
summarize('Table',"Measure","Price Growth", "ACT",[Price Growth], "PY",[Price Growth PY], "FC",[Price Growth FC])
)

or refer this

column header grouping
https://www.daxpatterns.com/dynamic-segmentation/
https://community.powerbi.com/t5/Desktop/Matrix-Display-Values-above-Columns/td-p/256905
https://community.powerbi.com/t5/Desktop/grouping-measure-results/td-p/456795