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

[sonya7]

Hello everyone, I am getting this error when I select all in the customer slicer. How should I edit the measure below to avoid this error?

Amount =

VAR yearmonth =

    VALUES ( Table1[yearmonth] )

VAR cus =

    VALUES ( Table1[customer] )

VAR agent =

    CALCULATETABLE(

        VALUES ( Table1[customer_id] ) ,

        FILTER (

            Table1,

            Table1[yearmonth] = yearmonth

                && Table1[customer] = cus

        )

    )

VAR sales =

    CALCULATE (

        SUM ( sales2[amount] ),

        FILTER (

            sales2,

            sales2[customer_id]

                IN agent

                && sales2[yearmonth]

                IN yearmonth

                && sales2[channel] = "Bank"

        )

    )

RETURN

    sales

[amitchandak · Accepted solution]

@sonya7 , use in here

VAR agent =

CALCULATETABLE(

VALUES ( Table1[customer_id] ) ,

FILTER (

Table1,

Table1[yearmonth] in  yearmonth

&& Table1[customer] in  cus

)

)