Data relationship

[SudhirMunjal]

Hi, for some reason I'm not able to create relationship between 3 tables.

1. 1st relationship between two tables. - company to company. Purpose is to filter the page with desidered companies.

2. 2nd relationship between table revenue and calendar. - date to date. Purpose is to filter the page with desired period.

I'm not able to make the second relationship active due to above error message.

Help in this regard is highly appreciated.

[SudhirMunjal]

Hi,

This is the relationship matrix amoung various tables.

The initial solution of single filtering is not working.

[bcdobbs · Accepted solution]

I suspect you might also have a bi directional many to many relationship between demographic and hist revenue. The four tables demographic, hist revenue, calendar and revenue would need to look like:

You would however be better to separate portfolio and company out into their own dimensions so you have a unique list of both which removes the many to many relationships.

[bcdobbs]

Have a read of:

Bidirectional relationships and ambiguity in DAX - SQLBI

[bcdobbs]

Can you send a screen shot of the rest of your data model? I suspect your date table is related to another table which in turn related demographic.

As an initial solution set the cross filter direction as single with demographic filtering revenue.