Forum Discussion

AlejandroPCar's avatar
AlejandroPCar
Icon for Helper IV rankHelper IV
9 years ago
Solved

How to make Contribution to Growth formula?

Hi!   I need help again. I need to calculate the contribution to growth measure (annual growth by share of the total).   So if my shoes exports growth 10% in 2015 and this year the shoes' share o...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi AlejandroPCar,

     

    Based on my test with your shared pbix file, you should be able to use the formula below to create a new measure to calculate Percentage of total. :smileyhappy:

     

    Percentage of total formula = 
DIVIDE (
    SUM ( EAM[Valor Agregado] ),
    CALCULATE ( SUM ( EAM[Valor Agregado] ), ALL ( EAM ) )
)

     

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi AlejandroPCar,

 

Could you post your table structures(including the measures you're using) with some sample data and your expected result, so that we can better assistant on the formulas? It's better to share a sample pbix file if possible. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. :smileyhappy:

 

Regards

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi AlejandroPCar,

     

    Based on my test with your shared pbix file, you should be able to use the formula below to create a new measure to calculate Percentage of total. :smileyhappy:

     

    Percentage of total formula = 
DIVIDE (
    SUM ( EAM[Valor Agregado] ),
    CALCULATE ( SUM ( EAM[Valor Agregado] ), ALL ( EAM ) )
)

     

     

    Regards