How to deal with many to many dimensions in Tabular?

[ovonel]

I have this model:

Emp Roles is an unpivot that has Manager1 and Manager2 from Contracts and Manager1 and Manager2 from Clients:

• Each Contract/Client can appear multiple times in Fact.
• Each Fact row belongs to only one Contract and only one Client

As expected, a given client can have different contracts… (And, a given contract can belong to multiple clients too).

Therefore clients and contracts is Many to Many too.

My problem is that when in Power BI I combine a manager from Emp Roles with a fact measure I get some wrong results.

Is there any way for this to work?

[v-cgao-msft]

Hi @ovonel ,

You seem to be related two fact tables using a many-to-many relationship, please refer to:

Relate many-to-many facts

A good model is half the battle, and Power BI prefers to use a star schema  when modeling.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data