Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
Solved! Go to 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.
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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
93 | |
87 | |
84 | |
70 | |
49 |
User | Count |
---|---|
141 | |
120 | |
112 | |
59 | |
59 |