Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Looking for some help with a problem I have that I have seen some community posts that I tried to no avail. Thank you ahead of time!
Have 3 tables - OPPTY, DATE, QUOTA
Have 3 Slicers
Need the 3 Slicers to filter both the OPPTY and QUOTA Tables.
I could set up different active relationships amongst the three tables and slicers and they would work but because I can't have multiple active relationships between these tables as they are connected already I am not able to.
@eegarlepp - It looks like your problem may be the bi-directional relationship between opp and quota. Does it need to be bi-directional?
Cheers!
Nathan
Thanks @Anonymous for your response. In the model are set the direction of those 2 tables from Both, to single and back and nothing. Below is how the relationship of the 2 tables is setup. The cardinality has to be Many to Many due to how the Quota table was created which was by way of unpivoting the original table.
Hope this helps...
User | Count |
---|---|
98 | |
91 | |
84 | |
72 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |