Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Rajan_AN
Frequent Visitor

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

Rajan_AN_0-1710341242676.png

2 REPLIES 2
Daniel29195
Super User
Super User

@Rajan_AN 

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? 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.