Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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...
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
90 | |
81 | |
65 | |
65 | |
60 |
User | Count |
---|---|
170 | |
114 | |
102 | |
73 | |
69 |