Count Number of Order ID

[MrMP]

Hi,

I have original table as following:

Order ID	Product ID	Sales
1	P1	100
1	P2	150
2	P2	200
2	P1	200

Then in calculated table, there is crossjoin for Product IDs

Product ID	Product ID	Same Order ID
P1	P2	xxx

How to calculate how many times Product P1 and P2 appeared on same Order ID

Thanks!

[v-rongtiep-msft]

Hi @MrMP ,

Is the second table above the expected result? If so, why putting P1 and P2 in different columns and what if there are other product IDs? If the Same Order ID Column is the id column of the previous table?

Best Regards

Community Support Team _ polly

[MrMP]

The idea is to compare every product ID with every other product ID and get the unique number of Order IDs. Thats why there is cross join of all products between those products. 
They are in different columns so graph charts can be used. 

[negi007]

@MrMP if you want you can create below simple matrix visual which can do the job for you.

I hope it helps you.

[MrMP]

Thank you for your help, but I need it in calculated table so it can be used further.