data modelling and DAX

[Tito]

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

[Tito]

Hi Pijush,

Thank you 

[PijushRoy · Accepted solution]

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