Sumx? All? 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-robertq-msft]

Hi, 

Have you followed the DAX formula posted by Russell-PBI to find the solution to your problem?

If so, would you like to mark his reply as a solution so that others can learn from it too?

Thanks in advance!

How to Get Your Question Answered Quickly 

Best Regards,

Community Support Team _Robert Qin

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

[Anonymous]

Yes I did, already selected as a solution

[Russell-PBI · Accepted solution]

Hi @Anonymous, something like this should work:

DIVIDE(
     SUM(SOA[Avg_Rat])
,    CALCULATE(SUM(SOA[Avg_Rat]), ALLSELECTED(SOA[Owner]))
)

It sums Avg_Rat as affected by all attributes (Owner, Yes) and divides that by the sum of Avg_Rat across all Owners but still affected by Yes.