Look up DAX function for a search string

Hi Anonymous ,

The reason why this error occurs is that there is many to many relationship between the matched fields referred in LOOKUPVALUE function, and it is not caused by the text "Payroll processing representative".

To resolve the issue, you can change the formula as follow:

PPR =
CALCULATE (
    FIRSTNONBLANK ( 'Account Team Member'[UserId], 1 ),
    FILTER (
        ALLSELECTED ( 'Account Team Member' ),
        'Account Team Member'[AccountId] = Account[Id]
            && 'Account Team Member'[TeamMemberRole] = "Payroll processing representative"
    )
)

Best Regards,

Amy

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.