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 ,

 

Enable the sum option for the column. 

 

Or we can create a measure to work on it.

Measure = SUM(Table1[variance %])

 

 

 

  • mason23's avatar
    mason23
    Helper I
    7 years ago

    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'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.