Forum Discussion

Tito's avatar
Tito
Icon for Helper IV rankHelper IV
2 years ago
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...
Need Help
  • PijushRoy's avatar
    PijushRoy
    2 years ago

    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

PijushRoy's avatar
PijushRoy
Icon for Community Champion rankCommunity Champion
2 years ago

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