Calculate contribution to growth

[Ali_Chibani]

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 

Car_sales_Ontario.pbix

[Anonymous · Accepted solution]

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.

[Ali_Chibani]

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