Calculating Measure total as "Percentage" using other two measure totals

[abazzan]

Hello PBI Community,

I have the following table and want to calculate the total of variance of consumption between the total of "Actual Consumption" and total of "Predicted Consumption". Currently the Actual Consumption and Predicted consumption and Variance consumption are all measures. 

I was wondering if its possible that I can get the total of Variance consumption as (Total of Actual / Total of Predicted ) - 1 * 100.

So the total of Variance consumption will be -6.72%. 

Same goes for the Variance Cost. 

Thank you very much.

[Anonymous · Accepted solution]

Hi @abazzan ,

I create a sample to have a test and I couldn't reproduce your issue.

Variance Consumption = 
DIVIDE( CALCULATE(SUM('Table'[Actual Consumption])) , CALCULATE(SUM('Table'[Predicted Consumption])))-1

 Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vanessafvg]

can you share the data in text format?