Measures as values and columns in matrix..

[Anonymous]

Hi,

I have several measures that i would like to show in a table. I would like 4 columns that each has three measures by area.

The table I'm looking to create looks like this: 

Area 1	YTD	YTD LY	Change (%)	Change (Value)
Import	10	12	-16,67 %	-2
Export	9	7	28,57 %	2
Difference	1	5		-4
Area 2
Import	8	7	14,29 %	1
Export	4	6	-33,33 %	-2
Difference	4	1		3

Area would be my Rows, Columns would need to be the description of what the measures show and then values would be my measures...

I've tried switching values to show on rows, but I need to show measures on several columns in my table visual.  

Does anyone have a nice solution to this? Would a calculated table be a solution and if so, how?

Thanks!

[amitchandak · Accepted solution]

@Anonymous , I think you need a calculation group with the custom column. I tried something like this

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to Dimension Conversion. Complex Table display : https://youtu.be/qMNv67P8Go0