Can't create active relationship because of already existing one

[Anonymous]

Hello,

I have 3 tables: SESSION, LIFT_ANALYSIS that is calculated from SESSION and CALENDAR

I have two filters: DATE & B2B_B2C_SESSION so my user can see B2C sessions from web of particular date.

The problem is I have already linked SESSION and LIFT with B2B_B2C_SESSION but can't do the same with DATE with CALENDAR table ...

Thanks you by advance for your help !

[Anonymous]

@Anonymous 

Hey!

If I understand your problem correctly you have:

1. A relationship between the CALENDAR & UK_SESSION_DM tables

2. A relationship between the UK_SESSION_DM & SESSION_FREQ_TABLE

3. A need to create an active relationship between the CALENDAR & SESSION_FREQ_TABLE

If the above is correct, you cannot create an active relationship in step 3 because there is already a relationship between CALENDAR & UK_SESSION_DM & the relationship specified in step 2.

You can create an inactive relationship and leverage that relationship via DAX. Click the link below for a good blog post concerning the problem & possible solutions:

http://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in-power-bi

When faced with this problem, I use USERELATIONSHIP. There are other good blog posts concerning USERELATIONSHIP--just search Google.

Hope this helps.

[Anonymous]

That's the issue.

I found results on Google but on Measure, not Column.

The problem is that i have a calculated column in the SESSION_FREQ_TABME and depending on date chosent from CALENDAR, the chart that I use get value based on those date (and the B2B_B2C_SESSION filter before that works good).

And this particular issue, i didn't find anything on it.

But still digging 😄

Thanks by advance !

[Anonymous · Accepted solution]

Well I found a solution just now, i don't know if it's the BEST but I think it works on long term.

Basically my second table is a summarize + union of the first table and i have those two fields : B2B_B2C_SESSION and DATE so i concatenated those two variables into one field B2B_B2C_SESSION_DATE and used it as a key field when summarize for the table and so used the variable for the relationship.

Then, when I use the slicer on the first table either for B2B_B2C_SESSION or DATE, it works perfectly 🙂