Forum Discussion
Relationship not working
- 6 years ago
It's pleasant that your problem has been solved, 😁 please accept the reply as solution, that way, other community members will easily find the solution when they get same issue.
Regards,
Lin
Mainly this :
But also this
I tried adding columns in RAW_Errors Table using RELATED(__Calendar[Week]) , interesting fact is that tooltip picks up the relationship and enables autocompletition with Tab, but column is just blank.
burnt_fingers one of the bad thing in this model I see is that cross filter direction to both, make it single direction, I don't see the reason why you have all the relations set to both direction.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
- burnt_fingers6 years agoAdvocate I
Switch to single direction. No Change.
- v-lili6-msft6 years agoCommunity Support
Could you please share your sample pbix file for us have a test, that will be a great help.
there should be something wrong in other.
Regards,
Lin
- burnt_fingers6 years agoAdvocate I
All,
It was my mistake. While formatting was set , the actual data type in RAW_Errors was Date/Time. After switching to Date only relationship kicked in.
Thanks for your assistance all !