Forum Discussion

Twister8's avatar
Twister8
Helper II
9 years ago

SUMMARIZE DAX - multiple columns ...cannot be conver

Hi guys

 

I have problem in SSAS when I try create the measure with tabular model

 

'Teste:='
SUMMARIZE(
table,
table[cd],
"test",
Sum(table[value])
)

I need sum some values, value1 + value2 + value3 and group by cd but i have this error:

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

 

In sql language is like this:

SELECT
    OrderDate,
    SUM(SalesAmount) + sum(value2) + sum (value3) AS Sales
FROM  
    FactInternetSales
GROUP BY
    OrderDate
Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    A measure aggregates to a scalar value. What you've written returns a table, so it is not a valid measure. What do you expect this measure to do once it fetches this table? You've added a column, so I'm guessing you want a sum or average of that new column?