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

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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.

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

Anonymous can you paste your code rather than image?

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

    also what you mean by it doesn't work, you have to be more detailed. and provide the full error message your are getting. I cannot make assumption what error message you are seeing.

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

    amitchandak not sure how it is different than what is already there, it just need to filter blank values. 

  • 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.