Sumx with all or filter?

Question

Hello everyone, I have the followin measure.

SumAvg = SUMX(SOA, SOA[Avg_Rat]) that I'm using it through a stacked collumn chart and showing as percent of the grand total

When I filter the year into the chart the result is correct, but when I remove the filter the the number changes for all years.

The following print is the correct percent

But after I remove the filter and show all year the number changes and it is incorret, how can I'm able to keep the correct percent for all years?

The corret is 31% not 7 %

PS: I'm using the year into the small multiple.

anonymous · Accepted Answer

It is solved, thank you for your timehttps://community.powerbi.com/t5/DAX-Commands-and-Tips/Sumx-All-Filter/m-p/2348243#M59463

Forum Discussion