Matrix Visual - Attributes on Different Rows

[Ormy28]

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!

[v-venuppu · Accepted solution]

Hi @Ormy28 ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

Regards,

Rama U.

[Cookistador]

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 

[Cookistador]

Hi @Ormy28 

The following dax measure should help you

Total =

VAR CountValue = CALCULATE(COUNT('Table'[Transaction Type]))+0

RETURN

IF(

        ISINSCOPE('Table'[Transaction Type]),

            CountValue,

            CALCULATE(COUNT('Table'[Fulfilled]),'Table'[Fulfilled] = 1)

)

[Ormy28]

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?