Forum Discussion

_-Christian-_'s avatar
_-Christian-_
Frequent Visitor
1 year ago
Solved

Userelationship is not working

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...
  • mark_endicott's avatar
    mark_endicott
    1 year ago

    _-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. 

ValtteriN's avatar
ValtteriN
Community Champion
1 year ago

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/