cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Patron
Post Patron

Relationship with Bridge table

Hi,

 

i have a problem of creating relationship with bridge table.

 

i have 2 database that have same column 'department'. i wanted to make a relationship to make a slicer. but it didn't let me have active relationship. so created Bridge table like below. but it still doesn't let me make relationship..!

 

what do i miss here??

 

Department.PNGDepartment bridge.PNGrelationship department.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IV
Super User IV

Re: Relationship with Bridge table

@colourfullife change to this, double check table and column name, basically filter out blank values. Would appreciate Kudos 🙂 if my solution helped.

 

Bridge Department =
DISTINCT (
UNION (
  CALCULTETABLE ( VALUES ( 'Date - Supply'[Department] ), 'Date - Supply'[Department] <> BLANK() ),
 CALCULTETABLE ( VALUES ( 'Date - Services'[Department] ), 'Date - Services'[Department] <> BLANK() ) 
)
)

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

14 REPLIES 14
Highlighted
Super User IV
Super User IV

Re: Relationship with Bridge table

@colourfullife what happens if you try to make a relationship? Do you get any error? Make sure there is no blank/null value in bridge table.

 

Would appreciate Kudos 🙂 if my solution helped.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Highlighted
Super User IV
Super User IV

Re: Relationship with Bridge table

@colourfullife based on slicer image, if it is from bridge table, seems like there is blank value and that is the issue. 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Highlighted
Post Patron
Post Patron

Re: Relationship with Bridge table

thanks for your reply @parry2k 

it ask many to many both relationship for one and one for single relationship.

Result of relationsiso.PNG

and one of departments has blank. so in bridge table there is a blank..!

 

how can i make a bridge without no take blank if it;s the problem?

 

thanks,

 

 

Highlighted
Super User IV
Super User IV

Re: Relationship with Bridge table

@colourfullife how you are creating bridge table? 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Highlighted
Post Patron
Post Patron

Re: Relationship with Bridge table

@parry2k 

this is how i made a bridge table.

Department bridge.PNG

Highlighted
Super User IV
Super User IV

Re: Relationship with Bridge table

@colourfullife change to this, double check table and column name, basically filter out blank values. Would appreciate Kudos 🙂 if my solution helped.

 

Bridge Department =
DISTINCT (
UNION (
  CALCULTETABLE ( VALUES ( 'Date - Supply'[Department] ), 'Date - Supply'[Department] <> BLANK() ),
 CALCULTETABLE ( VALUES ( 'Date - Services'[Department] ), 'Date - Services'[Department] <> BLANK() ) 
)
)

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

Highlighted
Super User IV
Super User IV

Re: Relationship with Bridge table

@colourfullife or you can also change  your DAX expression like this, may be quick and easy to read.

 

Bridge Department = 
FILTER (  <your existing dax expression >, [Department] <> BLANK() )

 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Highlighted
Post Patron
Post Patron

Re: Relationship with Bridge table

@parry2k 

 

Sorry can you write all of them please? because when i tried to put  ;Department <> blank () ) at the end of my dax, it doesn't work.

Highlighted
Super User IV
Super User IV

Re: Relationship with Bridge table

@colourfullife can you paste your code rather than image?






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors