%Percentages Contribution between 2 lines based on filtering

[Chanleakna123]

hi all , i need your support , currently i am using below formula to have a %Percentages 100% out of this 2 lines chart , but when i filter Category or sub category , the result of both turn out less than 100% , which only 60% or 50% as of total , i think sth wrong with this calculation , what we want is , to have %Contribution = 100% based on whatever we filter above. 

[jdbuchanan71]

@Chanleakna123 

Where you want the ALL for your divide is on the field that is in the Legend of the chart.  For example, if the legend is on Region it would be like this.

% Contribution Updated = DIVIDE(SUM(Canadean[Value]),CALCULATE(SUM(Canadean[Value]),ALL(Canadean[Region])))

 The charts on the right use the updated measure and always add up to 100% even with filters applied

[Fowmy]

@Chanleakna123 

Can you share more information on this issue, better attach a sample PBIX file?

What is the legend of the chart ? are there any other measures here? 

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn

[Chanleakna123]

hi @Fowmy  , Legend is Column Name : Company . 

which is from raw data , no measure there 

[jdbuchanan71 · Accepted solution]

@Chanleakna123 

Since the legend is on Company try this.

% Contribution = DIVIDE(SUM(Canadean[Value]),CALCULATE(SUM(Canadean[Value]),ALL(Canadean[Company])))

[Chanleakna123]

@jdbuchanan71  Brilliant , 

thanks you so much . 

[Fowmy]

@Chanleakna123 

Can you share some sample data? Also, mention the visual you are using here.

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn

[Chanleakna123]

hi @Fowmy  , the data are in connected to each other 😞