Forum Discussion

ScotsSailor's avatar
ScotsSailor
Frequent Visitor
8 years ago
Solved

Calculate Percentage Difference Between Table Column Totals

I have a simple table showing values for two different years of data. I want to show the total year to year percentage difference in the last column (YOY % Change) in the total row at the bottom of t...
  • Thejeswar's avatar
    Thejeswar
    8 years ago

    Hi ScotsSailor,

    I tried re-creating your requirement and it seems to work the way that you are expecting it to work

     

    I have created 2 measures and below are the codes for them

    Measure = SUM(Table1[JV_Tot]) - SUM(Table1[JV_tot_17])
    Measure 2 = [Measure]/SUM(Table1[JV_tot_17])

     

    The Below is the screenshot

     

     

    One possiblity why the percentage not getting displayed in totals is, you have created the YOY Change and YOY% Change as columns and given don't summarize as the aggregation rule for YOY% change

     

    Also keep in might for this creating YOY% Change as column will not give the right values for your total even if they start appearing in totals

     

    Hope this solvesyour issue!!!

Thejeswar's avatar
Thejeswar
Super User
8 years ago

Hi ScotsSailor,

I tried re-creating your requirement and it seems to work the way that you are expecting it to work

 

I have created 2 measures and below are the codes for them

Measure = SUM(Table1[JV_Tot]) - SUM(Table1[JV_tot_17])
Measure 2 = [Measure]/SUM(Table1[JV_tot_17])

 

The Below is the screenshot

 

 

One possiblity why the percentage not getting displayed in totals is, you have created the YOY Change and YOY% Change as columns and given don't summarize as the aggregation rule for YOY% change

 

Also keep in might for this creating YOY% Change as column will not give the right values for your total even if they start appearing in totals

 

Hope this solvesyour issue!!!

  • ScotsSailor's avatar
    ScotsSailor
    Frequent Visitor
    8 years ago

    It did indeed solve the issue and you guessed it, I was using columns instead of measures. I'm very greateful for your prompt response. I am just beginning to understand Power BI, having spent quite some time with PowerQuery and Pivot tables.

     

    Best regards,

    ScotsSailor