Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |