Get the percentage for each year, not for the total

[yaelzi]

Hello there, 

I have a ribbon chart that shows the evolution of the weight of phone parts through the years.
I would like to know the breakdown for each year.

Here is the measure I use : 

Parts weight (kg) average per phone Model (%) = 
DIVIDE(
    SUM(PHONE_PRODUCTION[Production]) * [Parts weight (kg) average per Model],

    CALCULATE(
        [Parts weight (kg) average per Model],
        KEEPFILTERS(VALUES('PHONE_PARTS'[Model name])),
        ALLEXCEPT(PHONE_PARTS, PHONE_PARTS[Group name], PHONE_PARTS[Material])
    )
    * CALCULATE(
        SUM(PHONE_PRODUCTION[Production]), 
        ALLSELECTED(PHONE_PRODUCTION[Year of production])
    )
    ,
    0
)

And here is the result I get : 

X Axis = Year of production

Y Axis = the above measure (Parts weight (kg) average per phone Model (%))

Legend = part category (it has 3 types, represented by the 3 colors)

The problem I have is that it calculates the percentage of the total selected period (here 2013 to 2016) and not for each year.

When all the values added up, you get 100%. This is not the behavior I want. I want the sum to be 100% for each year.

Here is an example of what I would like to get : 

What is wrong with my measure ? 

It definitely comes from the denominator since DAX divides each value by the entire period. 

I tried almost everything (ALLEXCEPT, ALLSELECTED, ALL, KEEPFILTERS) but nothing works...

Thanks for your help !

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...