Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm having issues with this and I've looked around but I can't quite solve it on my own.
Current Situation:
I have two tables with data, L+7 data and L+SD data.
The tables are formatted identically and both contain data on 2 different channels. What I've done is append L+7 with L+SD so that I was able to use visual slicers that would filter for L+7 vs. L+SD and channel 1 vs. channel 2.
I then made another table that merged L+7 and L+SD so that I could have a calucated column for DVR lift, or rather the number of impressions from L+7 - L+SD. Using that column I created two more calucated columns in the report that deal with the % total and the % lift.
I now have a merged table and an appended table, both with L+7 data and L+SD data. How can I use my appended table slicers with my merged data visualization card?
Should I have tackled this differently from the start?
Thanks in advance! Hoping someone can help.
You may create relationships and then take advantage of USERELATIONSHIP in DAX.
Thank you for your suggestion!
I've tried to make relationships between the tables work but no such relationship can be created since I have a demo sort table.
This demo sort table is to help organzie my demos so they appear in the order I want.
User | Count |
---|---|
94 | |
89 | |
79 | |
77 | |
71 |
User | Count |
---|---|
116 | |
107 | |
88 | |
64 | |
63 |