One of my dimension tables won't connect to the facts table - Relationship problem?

[Roodakker]

Hi, 

I have a table showing historical statuses made in a process. I've imported a staffing file to be able to filter out the cases handled by work titels. The oranged-out columns "E-mail" and "Status changed by" are both e-mail adresses that perfectly match so this is what I used for creating the relationship. One to Many - from Staffing table to Status history table. 

Somehow it won't work anyways. Can anyone please help me solve this? 

The other relationships going from Staffing is the same kind of relationship, but connecting to 4 different processes. 

Thank you for helping me out, 

Ronja

[mlsx4]

Hi @Roodakker 

Relationship seems to be properly done. Even cardinality.

Are you sure, your problem is not in some filtering in the report or the measures you may have defined?

[Roodakker]

Thank you for checking, so frustrating.. 

There is no filtering or measures used on either the visuals or page 😞 

[mlsx4]

And what fields are you trying to show or are you using?

[Roodakker]

[mlsx4]

Hi @Roodakker 

I have replicated your scenario and it is working perfectly.

I would suggest you to check in Power Query and trim both columns, be sure that both are same type (text) and even delete the relationship and create it again. As you can see it is working for me.

[Roodakker]

Thank you for testing a replicate of my issue. I tested all of your suggestions and even removed the query and added it again. Still won't work. 

As you say, it should work, but somehow it doesn't.. 

[mlsx4]

Have you tried to isolate the two tables? I mean, try them without any other relationship/filters, etc. And then add, step by step the other relationships. I don't really know what is happening, but I think the only way you'll find the problem is by leaving the basic and then try to reach what you have now. That is, a kind of "debugging"

[Roodakker]

Thank you for your suggestion! I have now isolated the problem, but still don't know why and how I can solve it. 

The dimensiontable works perfectly fine until I add my Calenderauto table and mark it as "Calender table". If I don't mark it as Calender table the relationships still work, but as soon as I mark it the connection breaks. 

Any ideas? 

Thanks! 

/Ronja