Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Multiple Relationships between Tables

I'm having some issues with the relationships between my tables. Essentially I have a Sales table, a Quota table, and a Calendar table. The Sales table is very extensive and based on the way the repo...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    Anonymous like date table, you should have other dimensions, like region and have a relationship on that table with these sales and quotas tables, and once you do that, you will able to sales and quota for each region and will able to filter from this new region table.

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos 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
6 years ago

Anonymous like date table, you should have other dimensions, like region and have a relationship on that table with these sales and quotas tables, and once you do that, you will able to sales and quota for each region and will able to filter from this new region table.

 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos 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.⚡