Forum Discussion
Solved
data modelling and DAX
Hello everyone, I have 3 tables: Table 1 (list of all names), Table 2 (Client table), Table 3 (Product table). What is the best way to link the tables in the data model? I want to create a matri...
Hi Tito
Create a Many to One relationship between 1st Table and 2nd Table with Name column
Create a Many to One relationship between 1st Table and 3nd Table with Name column
Create 2 measure to calculate Client count & Product count
In Matrix visual, take name from 1st Table and use 2 created measure
In Slicer, use name from 1st table
If your requirement is solved, please make sure to MARK AS SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.
Thanks
Pijush
Lets Connect Linkedin
Hi Pijush,
Thank you