Forum Discussion
Relationship Direction issue with bridge table
Anonymous
im assuming the reasont you have that many bi directional filter is because you want dimensions to filter each other.
if that so ,then this is the not the best approach.
what you should do, is create a measure= calculate ( sum(fact_table[col_fact] ) , crossfilter ( key_1, key_2 , both ) )
and you add it to the filter pane to the slicers that reads from other dimensions as : measure is not blank () .
so basically, what you are doing, you are enabling bi directional filter only in the measure.
this way, i suppose your bi directional that you want to enable for the bridge table would be applicable .
let me know if this helps .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🙏
Can you help me with fact_table[col_fact] what should i Replace this one with ? LWR or Bridge table?