Matrix table with multiple measures as rows

[m_jacobsen]

I am trying to make a table similar to this below from Tableau:

As I have marked with red, it is combined of 2 table columns (Brugernavn + Afdelingskode), and for each of them are shown the measure name (as a row) plus the sum of the individual measures.

The 5 measures count number of tickets, and a ticket can be in multiple measures, not just one. So I cannot make the measure type as a custom column in stead 😞

I have tried creating this as a dynamic table in PowerBI, but this solution cannot handle when more than 1 measure is selected 😞

Any tips or ideas how this can be achieved in PowerBI? Thanks 🙂

[timalbers · Accepted solution]

Hi @m_jacobsen 
try it with the 'Matrix' visual type and drag all your measures into the value field.
They first will appear horizontally, but you can change that in the formatting settings:
Go to Values > Convert values to rows

[m_jacobsen]

You sir, are a genius! Thank you so much, just want I wanted 🙂