CALCULATE and USERRELATIONSHIP not working

[GJ217]

Hi,

I'm getting an error message the following error message "USERELATIONSHIP function can only be used in the CALCULATE" with the below measure I have written and I'm not sure where I have gone wrong, but I'm definately using CALCULATE and USERELATIONSHIP.

Leavers VOL = CALCULATE(COUNT(Person[PersonID]),

USERELATIONSHIP(Dates[Date], Person[TerminationDate])+0,

FILTER(Person,Person[TerminationReason] IN{"Resignation - VOL","Retirement - VOL"}))

Assistance is much appreciated

[GJ217]

@tamerj1 

Works perfectly thank you.

[tamerj1 · Accepted solution]

Hi @GJ217 
You may try it this way

Leavers VOL =
CALCULATE (
    COUNT ( Person[PersonID] ),
    USERELATIONSHIP ( Dates[Date], Person[TerminationDate] ),
    FILTER (
        Person,
        Person[TerminationReason] IN { "Resignation - VOL", "Retirement - VOL" }
    )
) + 0