Forum Discussion
Filter data based on another visual table
Hi, This seems pretty simple to do but for some reason I couldn't figure it out. I have 3 calculated tables as below and my goal is to have table B/C only show the Account CSN that's showing in tab...
Anonymous thanks. Is the relationship single or both cross filter direction? See if this post helps explain why that matters
https://radacad.com/one-dimension-filters-another-dimension-in-power-bi
For your example i suggest you create measures using USERELATIONSHIP instead of calculated tables. You'll need inactive relationships to make this work.
AllisonKennedy
Community Champion
Community ChampionAnonymous Glad you have it working. Do be care with the both cross-filter direction. It will add lots of ambiguity to your model. Watch the video associated with this blog if you have time, it explains it well with simple sample data for demonstration: https://www.sqlbi.com/articles/bidirectional-relationships-and-ambiguity-in-dax/