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

PaulDBrown's avatar
PaulDBrown
Community Champion
5 years ago

If the fields in the “data” table are related (sets and subsets), you don't actually need three relationships. All you need is the one-to-many relationship with the field with the highest granularity in the tables. You can then use whichever field from the dimension table in measures, visuals, slicers etc...

so just make sure the relationship is created with the field with the highest granularity.

 

If the fields are unrelated (independent values) I would recommend you create a separate dimension table for each field.