Forum Discussion

Tito's avatar
Tito
Helper 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 matrix where I calculate the number of clients from table 2 (table client) and the number of products from table 3 (table product) each name?

In the matrix from which table I need to take the Name column?

I also want to build a slicer of names. 

 

List of all names:

 

Table Client:

 

Table Produkt:

 

Matrix Result: 

 

Slicer Result:

  

Best regards

Tito

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

2 Replies

  • PijushRoy's avatar
    PijushRoy
    Community 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