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

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:

    • aj1973's avatar
      aj1973
      Community Champion
      5 years ago

      First of all, i don't see the need to add inactive relationships unless you are going to use them for some calculations using UESRELATIOSHIP dax formula. Second keep active the only relatioship that is going to help you with your bar chart.

      Third, do you want to share a sample of your file maybe we can better understand the issue?