Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hey.
I am trying to link sales, which come from 3 different tables, to a target table.
Via the bridge table, I have no issue at all to project all the sales data per [Verkaufercode] in one table. However, I want to compare them to a certain target, per [Verkaufercode].
In my mind it seems to easy:
- a bridge to link the three different sales tables to get the sales per verkaufercode -> 'AM Bridge'
- a date table to create a date slicer which slices the data on the right column -> 'Datum' table.
- a target table that relates to both the date table and the bridge table -> 'TargetTest'
However, I cant link the date table to the target table because of ambiguity. I really don't understand this. I hope one of you guys could clarify what my thinking error is.
Thanks in advance!
Solved! Go to Solution.
Dear community,
I managed to fix it by myself by getting rid of cross filter directions. As soon as I added a second monthly target row (date) in the TargetTest table, the relationship changed from 1-to-1 to 1-to-many, which made me able to change the filter direction.
Thanks for reading it anyway 🙂
Dear community,
I managed to fix it by myself by getting rid of cross filter directions. As soon as I added a second monthly target row (date) in the TargetTest table, the relationship changed from 1-to-1 to 1-to-many, which made me able to change the filter direction.
Thanks for reading it anyway 🙂
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |