Error Multiple columns cannot convert to scalar value

[Durbslaw]

Hi,

I have this measure...

Day1LeaveCatergory = countx(Summarize('Leave Management',"Leave Day Catergory",FILTER('Leave Management','Leave Management'[DateDiff] = "1-Day")),[DateDiff])

which is meant to count the "1-Day" occurences in the DateDiff measure, I get the Expression refers to muliple columns. Multiple columns cannot convert to a scalar error.

Many thanks for the reads and responses.

Regards

[v-chenwuz-msft · Accepted solution]

Hi @Durbslaw ,

The problem is that you are using summarize() incorrectly.

SUMMARIZE (<table>, <groupBy_columnName>[, <groupBy_columnName>]…[, <name>, <expression>]…)

In your code,

1 you have missed one necessary argument <groupBy_columnName>.

2 <expression> should return a value rather than a table, the return of FILTER() is a table so that the error message.

Maybe you can try this expression to count the "1-Day".

COUNTROWS( FILTER('Leave Management','Leave Management'[DateDiff] = "1-Day"))

Or please share some example data and expect result if you need more help.

Best Regards

Community Support Team _ chenwu zhu

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