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 mul...
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
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