couldn't load the data for this visual error , caculation error in measure

[phillgrey]

Can anyone help, I keep getting the following error when trying to create a column with line series model. I have create two calculations using a SUM, converted the data type to an INT in SQL and also to a whole number in BI, still wont work. Any ideas? Thanks

[Rayshin · Accepted solution]

@phillgrey 

You can try using the "VALUE() function" in the column, but you should certainly be able to change it within power query

[phillgrey]

Thanks, Im trying to do it SQL side to help with performance but the power query work . Cheers!