Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to 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
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
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!
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
73 | |
72 | |
39 | |
31 | |
26 |
User | Count |
---|---|
97 | |
87 | |
43 | |
40 | |
35 |