Summarize error "La exp hace ref a var. Columns. They cannot concede. colum a esc"

[Syndicate_Admin]

Hello I am just learning and I have been looking for the error without having much solution.

Where I get the error"The expression refers to multiple columns. You cannot convert multiple columns to a scalar value."

I'm using the following code

I appreciate the help.

[v-yangliu-msft · Accepted solution]

Hi  @Syndicate_Admin ,

The summrize() function results in an entire table of data, and Measure displays only a value, not the entire table's data, so an error occurs.

Refer to:

SUMMARIZE function (DAX) - DAX | Microsoft Learn

ISBLANK function (DAX) - DAX | Microsoft Learn

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

It would be better if the expected results were shown in the form of pictures.

Best Regards,

Liu Yang

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