Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
MrMP
Helper III
Helper III

Count Number of Order ID

Hi,

 

I have original table as following:

 

Order IDProduct IDSales
1P1100
1P2150
2P2200
2P1200


Then in calculated table, there is crossjoin for Product IDs

Product IDProduct IDSame Order ID
P1P2xxx



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

 

Thanks!

4 REPLIES 4
v-rongtiep-msft
Community Support
Community Support

 

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. 

negi007
Community Champion
Community Champion

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

 

negi007_0-1632672510359.png

I hope it helps you.




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos



Proud to be a Super User!


Follow me on linkedin

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.