Forum Discussion
Relationship Direction issue with bridge table
I'm struggling to establish the correct connections in my report. I've attached a screenshot of my Bridge table and related tables. I aim to have bidirectional relationships with Crystal and LWR. However, due to the Date table, I'm unable to create relationships in both directions. What would be an alternative solution to this problem? Need Help Show and Tell Tips and General Comment Tricks
2 Replies
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! 🙏
