Get the percentage for each year, not for the total

Anonymous — Tue, 16 Apr 2024 09:50:26 GMT

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 !

Re: Get the percentage for each year, not for the total

lbendlin — Tue, 16 Apr 2024 21:46:48 GMT

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-Forum/ba-p/963216

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/1447523

topic Re: Get the percentage for each year, not for the total in DAX Commands and Tips

Get the percentage for each year, not for the total

Re: Get the percentage for each year, not for the total