dax not working on report view

soumit — Sun, 02 Jun 2024 20:41:09 GMT

Dear experts i need help, i dont understand why i cant use topn,filter,summarize function in dax , here is an example

CALCULATETABLE(TOPN(10,Car_sales,Car_sales[Horsepower],DESC)),its a very simple formula aims to give top values based on horsepower column of the Car_sales table the problem that im facing is its working in the Dax query view but not in the report view , its showing me this message " The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value. " why itsonly working on the query view
another example Top10Cars =
TOPN (10,SUMMARIZE ('Car_sales','Car_sales'[Manufacturer], 'Car_sales'[Model],"TotalSales", SUM ( 'Car_sales'[Sales_in_thousands] )),[TotalSales], DESC) this one aims to get the top 10 car manufatures and the model based on the sales again i can see the result in the query view but its showing this " The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value. "

Re: dax not working on report view

sjoerdvn — Mon, 03 Jun 2024 16:25:44 GMT

Your DAX query returns a table, so you cannot use it as a measure, since a measure should return a scalar value.
You could use it as a (calculated) table, but note that the query would be exdcuted when (loading) processing the model; so it will not take into account any slicers or filters.

Instead, you could also add a TOP N filter to a visual

topic dax not working on report view in DAX Commands and Tips

dax not working on report view

Re: dax not working on report view