Relationship not working

[burnt_fingers]

Hi All,

  I've run into another issue i cannot comprehend. 

  So i have 4 tables :

  RAW_In

  RAW_out

  RAW_error

  __Calendar

  Each of RAW tables is having creation date column that i want to connect to calendar table.

  RAW_in and RAW_out works without issues, but in case of RAW error relationship is not working. See below :

RAW_error sample data :

CREATION_DATE
Wednesday, July 8, 2020
Friday, January 17, 2020
Tuesday, June 2, 2020
Tuesday, June 2, 2020
Tuesday, March 24, 2020

RAW_in sample data :

CREATION_DATE
Friday, January 31, 2020
Friday, January 31, 2020
Friday, January 31, 2020
Friday, January 31, 2020
Friday, January 31, 2020
Friday, January 31, 2020

RAW_out sample data :

CREATION_DATE
Thursday, January 9, 2020
Thursday, January 9, 2020
Thursday, January 9, 2020
Thursday, January 9, 2020
Thursday, January 9, 2020

I want to use __Calendar[Date] to filter visuals being a combination like :

*Bar/Line chart, where Bars are RAW_in/out and line is RAW_errors.

Can any1 advise why this isn't working ?

I've tried deleting relationship and putting it back on both manual and using relationship manager but neither does work.

[Greg_Deckler]

@burnt_fingers - Define "not working". Looks like all of the relationships are active. What is causing you to believe that a relationship is not working?

[burnt_fingers]

@Greg_Deckler 

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.

[parry2k]

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

Read this post

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_fingers]

@parry2k 

Switch to single direction. No Change.

[v-lili6-msft]

hi @burnt_fingers 

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_fingers]

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 !

[v-lili6-msft · Accepted solution]

hi  @burnt_fingers 

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