Forum Discussion

Malo's avatar
Malo
Regular Visitor
6 years ago
Solved

operand error for sum with directquery

Dear all, I've an issue with the last version of Power BI (2.84.981.0 64-bit (august 2020)). I've opened an old report, last modified on 08th June 2020 (it work well with no problem), and I've added...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Malo ,

     

    You could create a measure using VALUE() function to convert text to number.

    Then use SUMX() function to calculate the sum of measure.

    Measure = VALUE(SELECTEDVALUE('Table'[Column1]))

Measure 2 = SUMX('Table',[Measure])

     
    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Malo ,

 

You could create a measure using VALUE() function to convert text to number.

Then use SUMX() function to calculate the sum of measure.

Measure = VALUE(SELECTEDVALUE('Table'[Column1]))

Measure 2 = SUMX('Table',[Measure])

 
Best Regards,

Jay

Malo's avatar
Malo
Regular Visitor
5 years ago

Thanks for the solution. It work well