Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 !
Solved! Go to 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 🙂
@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:
When faced with this problem, I use USERELATIONSHIP. There are other good blog posts concerning USERELATIONSHIP--just search Google.
Hope this helps.
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 !
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 🙂
User | Count |
---|---|
106 | |
86 | |
81 | |
74 | |
71 |
User | Count |
---|---|
112 | |
101 | |
96 | |
74 | |
67 |