Relationship between two tables

[medlalami]

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 create my Clustered bar chart in my page and wants to display the number of the Problems as values, against the Priority (the field coming from Data table), I got nothing :

But when I use the Priority field from Problems table, I got the correct result with the total for each priority.

I'm new with Power BI, so maybe I forget something important.

[PaulDBrown]

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.

[aj1973]

Hi @medlalami 

I think changing the active relationship to Both will do the work. 

[medlalami]

I do it but I got the same result.

[nvprasad · Accepted solution]

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

[medlalami]

I will try this solution.

[selimovd]

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]

[aj1973]

this one is not active

[medlalami]

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]

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?