Hiding measures under each Column Header and display them at last as it shows same values

[Kallis]

Hi Team,

I am trying to configure the Matrix Visual as mentioned here - 

I'm looking for Hiding measures under each column header and display them atlast as it shows same values.

I am hiding Column Subtotals, where these measures are visible along with other default column level Totals. I do not need all those Totals so I have disabled completely.

Measure 1 is the calculation based on the values between COMPANY 1 and COMPANY 2

Measure 2 is the calculation based on the values between COMPANY 1 and COMPANY 2

Sheet 2 is what I'm able to achieve as shown below

from PBI Matrix Visual

Sheet 1 - is the one TO-BE ACHIEVED.

Kindly let me know if any further details required. 

If possible, a quick resolution would be of great help as I'm new to Power BI. 

Thanks in advance.

Regards

Kalyan 

[Kallis]

Yes. Agreed, even I was thinking that the solution would be not so easy.

I thougt of considering InfoRiver custom visual. But, before proceeding with that I wanted to hear suggestions from Experts as I'm new.

I will discuss and get back to you.

Thank you very much Matt for immediate response.

[MattAllington · Accepted solution]

You would think it's easy, but it's not. Options include

1. build an asymetrical matrix using a table https://exceleratorbi.com.au/building-a-matrix-with-asymmetrical-columns-and-rows-in-power-bi/
2. use calculation groups
3. use a custom visual like InfoRiver
4. use Analyze in Excel and create an asymmetrical pivot table.