Display a measure in a Matrix

[Anonymous]

Hi all,

I have the following report, which I want to display in a Matrix.

Report:

Table1(soldto)	Table1(Material)	Measure
1	123	A
1	124	A
1	125	B
1	126	A
1	127	B
1	128	A
1	129	B
2	123	A
2	124	B
2	125	A
2	126	A

Matrix:

Soldto	A	B
1	4	3
2	3	1

Can somebdoy help me with that?

Many Thanks

lanko

[Ashish_Mathur]

Hi,

What is the logic based on which A's and B's have been generated?

[amitchandak]

@Anonymous , I am not getting by the third column is called aa measure

take Table1(soldto) on row
take Measure on column
and take count of Table1(Material) as values

[Anonymous]

The third "column" is not a column from a table but a measure.

I can't take put the measure "measure" as a column or row only in the field values. PowerBi doesn't allow that for some reason.

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

You need to change this measure to a calculated column.

Best regards,
Lionel Chen

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

[amitchandak]

@Anonymous , check if this can help

Segmentation
https://www.daxpatterns.com/dynamic-segmentation/
https://www.daxpatterns.com/static-segmentation/