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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
hpw
New Member

Attach ratio for product versus accessory

I'm trying to set up a relation between products purchased and the amount of accessory for that product has been shold. To achieve this, I have the next tables. 

  • Mapping table: Tells me to which sku which accessory (sp_refmodelno) belongs. A sku can have multiple accessories. 
  • Product table: Maps all sold and purchase data. 
  • Purchase orders: Information about the quantity bought per order/product
  • Sales orders: Information about the quantity sold per order/product

 

For instance, I want a report that shows me that sku DXSP001 has been bought 181 times and a accessoiry (DXCF03) has been sold 72.557 times. I also like to know the attach ratio (72.557 / 181). 

What calculations do I need for this? 

 

hpw_0-1640205599120.png

 

1 ACCEPTED SOLUTION
hpw
New Member

I found a solution by creating a relationship from the Mapping table directly to the Purchase Orders and Sales orders instead of having the Items table in between. 

View solution in original post

2 REPLIES 2
hpw
New Member

I found a solution by creating a relationship from the Mapping table directly to the Purchase Orders and Sales orders instead of having the Items table in between. 

lbendlin
Super User
Super User

Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services. Please show the expected outcome.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.