Forum Discussion
Calculate contribution to growth
Hello everyone,
I am trying to calculate a new measure that shows each car type's contribution to monthly and quarterly growths. For instance, as you can see in the image below, car sales rose 3.7% in March. I am interested in how much each car type (i.e., electric, sedan, and SUV) contributed to that 3.7% growth. Similarly, I am intersted in computing contributions to quarterly growths too. I attached the PBI fille.
P.S. March and Q2 were used as an example. In other words, I want to compute the contribution to growth for each month and quarter.
Your support is highly appreciated!
Sincerely,
Ali
Hi Ali_Chibani ,
Please try to create a measure with below dax formula:
Contribution Percent = VAR _a = SUMX ( FILTER ( ALL ( car_sales ), [Date] = SELECTEDVALUE ( car_sales[Date] ) ), [Sales amount] ) VAR _b = [$ growth] RETURN DIVIDE ( _b, _a )Please refer the attached .pbix file.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi Ali_Chibani ,
Please try to create a measure with below dax formula:
Contribution Percent = VAR _a = SUMX ( FILTER ( ALL ( car_sales ), [Date] = SELECTEDVALUE ( car_sales[Date] ) ), [Sales amount] ) VAR _b = [$ growth] RETURN DIVIDE ( _b, _a )Please refer the attached .pbix file.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hey Anonymous,
Thank you very much for your support on this!
How should I modify the measure to calculate the quarterly contribution to growth?
Sincerely,
Ali
