"The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value."

[Anonymous]

Hi,

I'm using the following equation:

=AllExcept(Tablename, Tablename[ColumnName])

And I get the following error:

"The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value."

How could I be getting this error if I'm specifying one column per the formula.

Thanks

[v-juanli-msft · Accepted solution]

Hi @Anonymous

Do you use this formula inside another formula or just put this formula in a measure or calculated column?

ALLEXCEPT would return a table with all filters removed except for the filters on the specified columns.

Reference:

https://msdn.microsoft.com/en-us/query-bi/dax/allexcept-function-dax

Best Regards

Maggie

[Anonymous]

Thanks Maggie,

Fundamentally, does a measure produce a single output which can produce multiple outputs only when the context is iterated on and changed?

For instance, if I had a table like:

- Color -

Red

Red

Blue

Yellow

And I made the following measure:

Values(Color)

Would it never produce the below column because the below column contains multiple values and thus produce a similar error as the one I'm experiencing?

Red

Blue

Yellow

Thanks again,

Buri

Edit: I see what you're saying. I was trying to pull this out of a larger formula so I could test it's output and adjust accordingly.  Thanks!