Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

CALCULATE and USERRELATIONSHIP not working

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 ...
Need Help
Show and Tell
Tips and Tricks
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi Anonymous 
    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
Anonymous's avatar
Anonymous
Not applicable
4 years ago

tamerj1 

 

Works perfectly thank you.