Forum Discussion

RanjanThammaiah's avatar
RanjanThammaiah
Helper V
6 years ago
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...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    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.

     

v-eachen-msft's avatar
v-eachen-msft
Community Support
6 years ago

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.

 

Related content