Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |