Forum Discussion
AdministratorSummarize error "La exp hace ref a var. Columns. They cannot concede. colum a esc"
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.
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.
1 Reply
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.