Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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

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 conv...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
8 years ago

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's avatar
    Anonymous
    Not applicable
    8 years ago

    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!