Forum Discussion

mason23's avatar
mason23
Helper I
7 years ago
Solved

Calculating Total Percentage Variance

Hello Power BI Experts, How can I display total % variance in a table. Left screenshot is my imported data. Thanks for the help!    
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi mason23 ,

     

    To update the formula as below.

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

    Pbix as attached.

     

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi mason23 ,

 

To update the formula as below.

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

Pbix as attached.

 

 

  • mason23's avatar
    mason23
    Helper I
    7 years ago

    Thank you! That works!