Forum Discussion

Rodriguez22's avatar
Rodriguez22
Regular Visitor
3 years ago
Solved

Customer master table as a Dimension or Fact table?

Hi everyone, I am working a data model with 4 fact tables - Sales (date level), Budget(month and product level), Salesman Route(date level), Orders (date level)- and 4 dimension tables - Customers, ...
Need Help
Tutorial Requests
  • parry2k's avatar
    parry2k
    3 years ago

    Rodriguez22 you will use DISTINCTCOUNT on customer id to get the unique list of customers instead of simple COUNT

     

    ✨ Follow us on LinkedIn and  to our YouTube channel

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    ⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
3 years ago

Rodriguez22 you will use DISTINCTCOUNT on customer id to get the unique list of customers instead of simple COUNT

 

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.