Format Causing Errors

DAX DAX Calculations
1

I am assuming a formula can only return one type of variable/ Class (integer, currency, text etc) as I am getting an error using the following formula

image

All of the numbers produced by the formula is correct however the top 3 units are currency however units sold need to be a general number. This is why i try casting it to a general number. This cast does work when placed in the context of a tile visual. However when i place it on a graph it causes an error in which no data appears.

image
image.png696×392 40.7 KB

what would be causing this?

Thanks for any suggestions,

2

Yes what you’re are saying is true unfortunately. All results have to be in the same format when using this technique.

3

Okay thats unfortunate, thanks Sam.