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
What does the data model look like?
Why have you created calculated tables? Can you just use Measures to calculate the Churn, Renew, New, etc.
If you do that, then you can use the measures as Visual level filters.
Hope that helps a bit, please share the DAX for the calculated table and your data model relationships view if you need more help.