Calculations using Dataset from SQL

[DJsummers]

Hi All

Help required and gratefully recieved! I am attempting to create a measure doing:

SUM(CumulativeWeightsView[RecordedWeight]-CumulativeWeightsView[StandardWeight])/CumulativeWeightsView[StandardWeight])

But it does not work - I can't even minus one value from the other:

The dataset is from an SQL database so wondering if the relationships are having an effect?

Let me know if I should have added more info.

Thanks Again
Dan

[DJsummers]

@Samarth_18 What a dumbo I am!

Thanks very much for the extremely fast response and the second time you've helped me out.
Dan

[Samarth_18 · Accepted solution]

Hi @DJsummers 

Please try below code:-

Variance = (SUM(CumulativeWeightsView[RecordedWeight])-SUM(CumulativeWeightsView[StandardWeight]))/SUM(CumulativeWeightsView[StandardWeight])