Forum Discussion

medlalami's avatar
medlalami
Helper I
5 years ago
Solved

Relationship between two tables

Hi all,   I created a relation between two tables (Problems and Data), for the following fields : Priority - Urgency - Status The relation is Many-To-One for all fields. Now when I want to ...
Need Help
  • nvprasad's avatar
    nvprasad
    5 years ago

    Hi medlalami,

     

    You need to create a measure by using  "USERELATIONSHIP" with the calculation function in dax to turn inactive relationships into active relationship.

     

    Refer 

    https://www.sqlbi.com/articles/using-userelationship-in-dax/

     

     

    Appreciate a Kudos! 🙂
    If this helps and resolves the issue, please mark it as a Solution! 🙂

    Regards,
    N V Durga Prasad

selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

Hey medlalami ,

 

which of the 3 relationships is active?

Can you do a double click on the connection and show us?

 

Best regards

Denis

  • medlalami's avatar
    medlalami
    Helper I
    5 years ago

    • aj1973's avatar
      aj1973
      Community Champion
      5 years ago

      this one is not active

      • medlalami's avatar
        medlalami
        Helper I
        5 years ago

        I can activate this relation, but I need to delete the other ones before. 

        I tried to delete the other existing relations, and activated this one > works perfectly, but when I try to relink the other fields (Urgency and Status), I got this message: