Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 h...
Need Help
Show and Tell
  • parry2k's avatar
    parry2k
    6 years ago

    Anonymous 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() ) 
)
)

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

parry2k , Sorry, I missed some of your updates. there was a time lag between I open and respond.

I just suggested the solution worked for me.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

amitchandak understood, basic proble was totally different and that's why I was just wondering how your solution will help.