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 converted to a scalar value."

 

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

 

Thanks

Need Help

2 Replies

    • 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!