Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Ali_Chibani
Frequent Visitor

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 

 

Ali_Chibani_0-1716402182615.png

Ali_Chibani_1-1716402657074.png

Car_sales_Ontario.pbix

 

 

 

 

 

1 ACCEPTED SOLUTION
v-binbinyu-msft
Community Support
Community Support

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 )

vbinbinyumsft_0-1716432556528.png

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.

View solution in original post

2 REPLIES 2
v-binbinyu-msft
Community Support
Community Support

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 )

vbinbinyumsft_0-1716432556528.png

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 @v-binbinyu-msft,

 

Thank you very much for your support on this! 

 

How should I modify the measure to calculate the quarterly contribution to growth?

 

Sincerely,

Ali

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors