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

[A_H]

Hi

I am tryin to do the below and receicing this mesage: A table of multiple values was supplied where a single value was expected.


Actual sales = CALCULATE (SUM (ORDERDETAILS[Gross Total After Discount]), FILTER(ORDERDETAILS,ORDERDETAILS[city] = ALL(SalesTargets[city])))

[Zubair_Muhammad · Accepted solution]

@A_H 

ALL(SalesTargets[city]) returns a single column table containing unique values in City Column

Depending on what you are trying to achieve you could do any of the following

Actual sales = CALCULATE (SUM (ORDERDETAILS[Gross Total After Discount]), FILTER(ORDERDETAILS,ORDERDETAILS[city] = MAX(SalesTargets[city])))

Actual sales = CALCULATE (SUM (ORDERDETAILS[Gross Total After Discount]), FILTER(ORDERDETAILS,ORDERDETAILS[city] in ALL(SalesTargets[city])))

Actual sales = CALCULATE (SUM (ORDERDETAILS[Gross Total After Discount]), FILTER(ORDERDETAILS,ORDERDETAILS[city] = SalesTargets[city]))