Formatting issue

Hi JamesBurke The Format function in Power BI DAX converts the data type to a string. This function is used to format a value as a string according to a specified format. Your measure [Total Kwh] most problably summing up your calculated column which is techincally not possible.

To overcome this situation, use sumx and value function to evaluate sum. For example:

Total = SUMX(
    orders,
    VALUE(orders[StringOrder])
)

Here orders[StringOrder] column have used format function and data type is text.

Hope this helps!!

If this solved your problem, please accept it as a solution!!

Best Regards,
Shahariar Hafiz