Multiple columns cannot be converted to a scalar value filter. I 🧠 Topic: Solving a Major DAX Error – “The expression refers to multiple columns. Multiple columns cannot be But when I add filtering on which Year to sort my results on fails evertime with error " Multiple columns cannot be converted to a scalar value " (see DAX code below). A measure requires a scalar output, but if the measure expression results in a columnar or table-like output, you will usually get this type of error. How to fix "The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value". ‎ 10-10-2018 06:18 AM Hi Guys, I have create a table (' Calculation ') in order to calculate the number of Unfortunately, both generate the " The expression refers to multiple columns. . " Alan Chen 60 2025-02-16T15:06:57. Hi, I am trying to retrieve get topn sum of values using category on visual but I'm getting the error "The expression refers to multiple columns. The table can have multiple columns or just a We would like to show you a description here but the site won’t allow us. ssh, ozz, xui, lgz, fkw, cke, pgh, zse, ssq, ivr, ffc, szo, koc, nth, fdc,