Forum Discussion
Matrix Visual - Attributes on Different Rows
Hi
I have a table of transactions that includes a Start Date along with two attributes, Transaction Type and Fulfilled.
Transaction Type is simply a three letter code and Fulfilled is just a 1 or 0.
| Start Date | Transaction Type | Fulfilled |
| 31/03/2025 | ARY | 0 |
| 31/03/2025 | ARY | 1 |
| 31/03/2025 | QXN | 1 |
| 31/03/2025 | TRP | 0 |
| 07/04/2025 | QXN | 0 |
| 07/04/2025 | QXN | 1 |
| 07/04/2025 | TRP | 1 |
| 07/04/2025 | TRP | 1 |
| 07/04/2025 | TRP | 0 |
| 07/04/2025 | QXN | 1 |
| 07/04/2025 | TRP | 0 |
I want to create a matrix visual with the Start Date as columns, and both the Transaction Type and Fulfilled as rows. The values would then just be the count of each Transaction Type and the count of 1s for Fulfilled:
| 31/03/2025 | 07/04/2025 | |
| ARY | 2 | 0 |
| QXN | 1 | 3 |
| TRP | 1 | 4 |
| Fulfilled | 2 | 4 |
The solution would also need to take into account that new Transaction Types can be added as time goes by, and these would need to be added to the matrix. Therefore, I ideally would like to avoid a situation where I had to update DAX with a new Transaction Type.
Totally at a loss as to how to acheive what I thought would be quite simple!
4 Replies
Hi Ormy28
The following dax measure should help you
Total =VAR CountValue = CALCULATE(COUNT('Table'[Transaction Type]))+0RETURNIF(ISINSCOPE('Table'[Transaction Type]),CountValue,CALCULATE(COUNT('Table'[Fulfilled]),'Table'[Fulfilled] = 1))Thanks for your reply.
How would you then use this measure? I was of the understanding that measures could not be used as rows in a matrix visual?
This is how I set up the matrix:
The measure is a values if I add a new Transaction type, it will be added automatically
