Matrix value that counts data

[Anonymous]

Hello everyone,

Thanks in advance for your time and help. 🙂 

Here is a sample of my table : 

I am trying to create a Matrix that counts the number of  transaction per "Responsable of transaction" and "Status of transaction". However my issue is that I have two columns "Responsable of transaction" to be taken into account.

The Matrix should look like that : 

The names in the Matrix above correspond to the list of responsables and is taken from another table : 'Responsable' [name].

I am looking for the "measure" that will be used as "value" in this Matrix to match my purpose. I have tried many things but cannot find the solution.

Thanks a lot for your help.

Any clue would be very appreciated.

Have a nice week-end

Gaspard 

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

Try Unpivot column in query editor.

Count "transactin n" directly without creating measure

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.