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

Anonymous 

Try like this

distinct(union(all(table1[Department]),all(Department)))