Forum Discussion
Anonymous
5 years agoNot applicable
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...
- 5 years ago
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
5 years agoCommunity Champion
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.