Forum Discussion
Solved
DAX Error: The Expression Refers to Multiple Columns. Multiple Columns Cannot Be Converted to a Scal
Hi All, i am getting the error for the below formula. Kindly can some one explain me what this error referring to? DAX Error: The Expression Refers to Multiple Columns. Multiple Columns Cannot B...
Hi RanjanThammaiah ,
Your DAX will return a table with multi columns, it couldn't be a measure. If you want a measure, you need add your expression before filter. If you want a table, you could use CALCULATETABLE() function to create a new table.
Table 2 = CALCULATETABLE(FILTER('SLI',SUM('SLI'[TERFYTD_PR])>4))To avoid misunderstandings, you could elaborate on your expected results and calculation logic.
Try like
Measure 2 = CALCULATE(countrows(FILTER(SLI,SUM(SLI[TERFYTD_PR])>41666)))
But what exactly you are trying to achieve, measure filter needs a context.