A table of multiple values was supplied where a single value was expected.

[Anonymous]

This has been working for the past several months but today I received an error saying, "A table of multiple values was supplied where a single value was expected." The statement is below. Any help on how to resolve this?

Pipeline = 
VAR pipeline = SUBSTITUTE ( LOOKUPVALUE ( 'hubspot-deals'[Pipeline], 'hubspot-deals'[Sales: Stripe ID], LOOKUPVALUE ( KPIEmployees[stripeid], KPIEmployees[email], 'hubspot-ind'[Email] ) ), "Sales - ", "" )
RETURN
    IF (
        ISBLANK ( pipeline ),
        "Direct",
        pipeline
    )

[v-eqin-msft]

Hi @Anonymous ,

Please provide me with more details about your table or share me with your pbix file after removing sensitive data.

Refer to:

How to Get Your Question Answered Quickly

Best Regards,
Eyelyn Qin

[PaulDBrown]

Pipeline is returning multiple values instead of a single value. Why? probably because one/both of  the LOOKUPVALUES is returning a list instead of a single value (but that's just a guess, since there is no sample data to go by)