Datamodel with multiple products in a salesorder

Power BI Data Model
1

@sam.mckay Do you have an example or showcasevideo with a datamodel that is the same or similar with the following example:

A (online) store is selling jeans, shoes and t-shirts. A customer can buy all those products in 1 order so there will be 3 orderlines.

In the showcases I have found there is always 1 order with 1 product so always 1 orderline.

I hope you can help me.

1 Like
2

Welcome to the Enterprise DNA Forum @NickvanDijk. We’re happy to have you in the community. To get started, I highly suggest you check these guides that Sam created for us to build a more collaborative environment. How To Use The Enterprise DNA Support Forum

3

Hi @NickvanDijk, we aim to consistently improve the topics being posted on the forum to help you in getting a strong solution faster. While waiting for a response, here are some tips so you can get the most out of the forum and other Enterprise DNA resources.

  • Use the forum search to discover if your query has been asked before by another member.

  • When posting a topic with formula make sure that it is correctly formatted to preformatted text </>.
    image

  • Use the proper category that best describes your topic

  • Provide as much contextn to a question as possible.

  • Include the masked demo pbix file, images of the entire scenario you are dealing with, screenshot of the data model, details of how you want to visualize a result, and any other supporting links and details.

I also suggest that you check the forum guideline https://forum.enterprisedna.co/t/how-to-use-the-enterprise-dna-support-forum/3951. Not adhering to it may sometimes cause delay in getting an answer.

Please also check the How To Mask Sensitive Data thread for some tips on how to mask your pbix file.

4

Hi @NickvanDijk ! Let’s imagine this scenario together. You will have :

  • A dimension for the products
  • A dimension for the customers
  • A calendar or date dimension
  • A dimension for the salesperson

Here’s an example :
Nick bought on the 1st of February 2021, 2 jeans, 3 t-shirts and one pair of shoes. The salesperson responsible of treating this transaction was Amira.
In the model, your fact sales will contain three orderlines :

CustomerID OrderID OrderItemID SalesPersonID Qtity Price OrderDate  TotalSales
1          100     1           10            2     100   01-02-2021 375
1          100     2           10            1     50    01-02-2021 375
1          100     3           10            1     125   01-02-2021 375

This tutorial can help you understand better the example you have : click here.

5

Hi @NickvanDijk, did the response provided by @amira.bedhiafi.pro help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query. Thanks!

1 Like
6

Thank you for this help @amira.bedhiafi.pro !!

1 Like
7

You are always welcome.