Forum Discussion

olegkazanskyi's avatar
olegkazanskyi
Icon for Helper II rankHelper II
3 years ago
Solved

USERRELATIOSHIP removes row context filters

I have inactive relationships between tables I am trying to activate with a simple CALCULATE measure:

 

MODIFICATION_COUNT = CALCULATE(sum(USER[MODIFICATION_COUNT]),USERELATIONSHIP(INCIDENT[OPENED_BY_ID],USER[USER_ID]))

 

 

Here is how relationships look (Many to One):

 

 

But the result doesn't look as expected

 

Does anyone know what is wrong?

Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago

    Your sum calculation is done on the dimension table ('User').  USERELATIONSHIP only works when invoked from the fact table ('INCIDENT').  It is ignored in your scenario.

1 Reply

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago

    Your sum calculation is done on the dimension table ('User').  USERELATIONSHIP only works when invoked from the fact table ('INCIDENT').  It is ignored in your scenario.