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,

 

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