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

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.