cancel
Showing results 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

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.

Sincerely,

Ali

Car_sales_Ontario.pbix

1 ACCEPTED SOLUTION
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 )
``````

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 2
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 )
``````

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.

Frequent Visitor

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

Announcements

#### 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 Monthly Update - June 2024

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

#### 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
Top Kudoed Authors