Forum Discussion

burnt_fingers's avatar
burnt_fingers
Advocate I
6 years ago
Solved

Relationship not working

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.

Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    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

7 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    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's avatar
      burnt_fingers
      Advocate I
      6 years ago

      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's avatar
        parry2k
        Super User
        6 years ago

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