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.

     

     

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!