Sumx with all or filter?

[Anonymous]

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.

[v-stephen-msft]

Hi @Anonymous ,

What is the formula for [Avg_Rat]?

Is it possible to provide some dummy data and expected results?

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

It is solved, thank you for your time

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Sumx-All-Filter/m-p/2348243#M59463