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

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

2 Replies

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    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