Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

I keep getting this error message 'The expression refers to multiple columns. cannot be converted.'

Hi All,

 

I'm calculating a new measure and this is my calculation: total june = calculate(sum(append1,append1[month] = June)) and it keeps returning the error message 'The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value'.  

 

Could anyone tell me why this is happening and how to fix it?

Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, Anonymous 

    Please try the formula as below:

     total june = calculate(sum(append1 [Value field]) , append1[month] = "June")

    or 

    total june = calculate(COUNTROWS(append1),append1[month] = "June")
     
    Best Regards,
    Lin

1 Reply

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    7 years ago

    hi, Anonymous 

    Please try the formula as below:

     total june = calculate(sum(append1 [Value field]) , append1[month] = "June")

    or 

    total june = calculate(COUNTROWS(append1),append1[month] = "June")
     
    Best Regards,
    Lin
Related content