USERELATIONSHIP not working?

[Sohan]

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 between DimCalendar[Datum] and FactAppointment[Boeking afspraak]. 

When using the following DAX I get the wrong results: 

NP = 

var numberOfNewPatients = 
CALCULATE(DISTINCTCOUNT(FactAppointment[PatientID]),
FILTER(FactAppointment, FactAppointment[EarliestDateBoeking] = TRUE() && FactAppointment[EarliestDateAfspraak] = TRUE()))

var finalMeasure = 
CALCULATE(numberOfNewPatients, USERELATIONSHIP(FactAppointment[Datum boeking], DimCalendar[Datum]))

RETURN finalMeasure

 
When I manually deactivate the relationship between DimCalendar[Datum] and FactAppointment[Datum afspraak] and activate the relationship between DimCalendar[Datum] and FactAppointment[Boeking afspraak] I get the correct result. 

Does Anyone know what I might be doing wrong?

[Anonymous]

Hi @Sohan ,

Has the problem be solved?

Please consider to mark the reply as solution if it's helpful.

[FreemanZ]

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.

[Sohan]

Tried an intermediate measure, but get the same result.

[FreemanZ]

try to add a physical column.

[FreemanZ]

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.

[Thennarasu_R]

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

[Thennarasu_R]

CALCULATE(numberOfNewPatients, USERELATIONSHIP(DimCalendar[Datum]),FactAppointment[Datum boeking]))

@Sohan 
Change like this Now It will Work,
Thanks,
Thennarasu

[Sohan]

Does not work unfortunately.