Unpivot & DAX

[MT123456]

Hello, 

I have a table that, simplified, looks like the below one: 

and I need to create a table/matrix that looks like the below: 

Is there a way to do it only using measures in DAX, without unpivoting the columns or creating new calculated columns? 

Thank you! 

[AlexisOlson · Accepted solution]

I don't think this is possible with only measures and no additional model objects.

Generally, you need a dimension to put on the matrix/table rows. This is possible without modifying the existing table but you'll need to create a new table with a column containing values "A", "B", "C" or create other model objects like field parameters or calculation groups.