Matrix

[Torudd-55]

Hi everyone reading this post!

I need help with creating a matrix with a calculated value in each cell.

What i want to achieve is to recognize the number of sales a kombination of two different items have together.

As an example, the table could be looking as below:

Orderno   item.no

1	12
	13
	14
2	13
	3
3	3
	13
	14
	15
4	14
	15
5	13
	3
6	12
	13
7	13
	14
	3

And the result of the measure i would like to get from this table is as below, the bold numbers:

item.no

3	12	13	14	15
3	0	0	4	2	1
12	0	0	2	1	0
13	4	2	0	3	1
14	2	1	3	0	2
15	1	0	1	2	0

Thanks in advance!

[v-eachen-msft · Accepted solution]

Hi @Torudd-55 ,

You could pivot item.no column in the query editor.

[amitchandak]

If the order number and item number are there in all rows. Count item_no, in the matrix, should give you the same.

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601