topic Re: Userelationship is not working in DAX Commands and Tips

Userelationship is not working

_-Christian-_ — Thu, 19 Dec 2024 09:23:47 GMT

Hello,

I have some problems by using userelationship in my data model. I am not sure why it is not working. I read a lot of articles in the forum but found nothing. Hope you can help.

My data model has the following form:

The relations are:
sn_incident_task ( task_number) <-> sn_task_sla (task_number), active
sn_incident_task (inc_number) <- sn_incident_metric (inc_number), active
sn_incident_metric (inc_number) -> sn_task_sla (inc_number), inactive

Lets take this simple Calculation to show my problem. I want to create a new column that draw a column from another column.

1. Measure with userelationship:

Assignment Group with relationship = CALCULATE(

VALUES(incident_metric[assignment_group (groups)]),

USERELATIONSHIP(incident_metric[inc_number], sn_task_sla[inc_number])

)

2. Without Userelationship to use only the active relation.

Assignment Group active = RELATED(incident_metric[assignment_group (groups)])

As you see in the picture, both columns are identical. (Beacause of sensitive data, I filter for other and blank.)

The result of the calculation is wrong. It is everytime use the active relation and not the inactive. For other inactive relations userleationships works.

What did I wrong?

Greetings
Christian

Re: Userelationship is not working

ValtteriN — Thu, 19 Dec 2024 10:13:21 GMT

Hello,

It might be good to use a measure instead of a column, but even in the event of using a column consider the following dax instead of use relationship

table 45

table 46

relation between ur1

46 Column = RELATED('Table (45)'[Value])

46 Column 2 =

var _v = [ur1]

RETURN

CALCULATE(MAX('Table (45)'[Value]),FILTER('Table (45)','Table (45)'[u2]=_v))

end result

This will give expected result without added relationships

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

Re: Userelationship is not working

mark_endicott — Thu, 19 Dec 2024 10:20:00 GMT

_-Christian-_ - The relationships in your screenshot are a mess. this model definitely has ambiguous pathways for filtering to travel and is very unlikely to give correct answers even if USERELATIONSHIP worked.

I can see you have an active one-to-many relationship from incident_metric to sn_incident_task, then an active one-to-many relationship from sn_incident_task to sn_task_sla - the calculation is following this routeway, and therefore USERELATIONSHIP does not need to be invoked.

I suggest you read up on Star Schema's in Power BI. I also have a useful blog on the impact of relationships - https://triangle.im/power-bi-mistake-7-why-bi-directional-relationship-issues-will-cause-headaches/

If this helps, please accept as the solution, it helps with others facing the same challenge.