Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

USERELATIONSHIP not working?

I have the following relationships in my data model:   There is an active relationship between DimCalendar[Datum] and FactAppointment[Datum afspraak]. There is an inactive relationship betwee...
Need Help
FreemanZ's avatar
FreemanZ
Super User
3 years ago

Be careful when using VAR. DAX Variable is actually a constant value: once defined, it never changes. So in your case, the filter argument with USERELATIONSHIP is actually useless.  Following your thread of thought, you can try to create a intermediate measure and it shall work.

  • Thennarasu_R's avatar
    Thennarasu_R
    Responsive Resident
    3 years ago

    FreemanZ 
    i Using USERELATIONSHIP in variables its working fine
    Thanks,
    Thennarasu

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Tried an intermediate measure, but get the same result.

    • FreemanZ's avatar
      FreemanZ
      Super User
      3 years ago

      try to add a physical column.

      • FreemanZ's avatar
        FreemanZ
        Super User
        3 years ago

        a imtermediate measure is not working in your case, because

        a measure is implicitely wrapped with CALCULATE. So it is like this

        CALCULATE(

            CALCULATE,

            USERELATIONSHIP()

        )

         

        As the filter argument of the inner CALCULATE has higher priority over its outer filter context (from USERELATIONSHIP), so again USERELATIONSHIP is useless.