(Duplicated dimention tables) or (single dimention table and inactive relationships)?

[barwe]

Hey, let's consider this simple star model shema: 

The result I'm trying to achieve is a sales table that I can filter by 3 type of owners:

Owner table is related to Client, Product and Sale table.

There are 2 ways I can make relations:

1) Duplicated dimention table

2) Single dimention table and inactive relationships

On the first examples, 3 different slicers are no problem at all. But is this even possible in the second example?

[Ritaf1983 · Accepted solution]

Hi @barwe 
It sounds like role-play dimensions, please refer to the linked videos :
https://www.youtube.com/watch?v=2BxaUXlx3K4

https://www.youtube.com/watch?v=H3-evk6-qpQ

The way that you should choose depends on the visuals and measures that you will need.

Take a look at the linked article too:

https://www.nathanprats.com/date-tables/

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly