Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
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
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.
Thank you for your help, but I need it in calculated table so it can be used further.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |