Calculating Total Percentage Variance

[mason23]

Hello Power BI Experts,

How can I display total % variance in a table. Left screenshot is my imported data. Thanks for the help!

[v-frfei-msft]

Hi @mason23 ,

Enable the sum option for the column. 

Or we can create a measure to work on it.

Measure = SUM(Table1[variance %])

[mason23]

Thank you for the reply. What I'm looking for is the individual row percentage.  The variance % column is computed from a calculated column formula . = Variance / Total Budget. The missing Variance % is the total($2,840,340.46 / $3,909,323) This should give me 73%

[Anonymous]

with right click on selected Variance field and click on Show value > as a percent of column total

[v-frfei-msft · Accepted solution]

Hi @mason23 ,

To update the formula as below.

Measure = DIVIDE(SUM(Table1[variance]),SUM(Table1[total budget]))

Pbix as attached.

[mason23]

Thank you! That works!