cancel
Showing results for
Did you mean:
Helper I

## Sumx? All? Filter?

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.

1 ACCEPTED SOLUTION
Resolver II

Hi @GuiGentil, 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.

3 REPLIES 3
Community Support

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?

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.

Helper I

Yes I did, already selected as a solution

Resolver II

Hi @GuiGentil, 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.

Announcements

#### Power BI Community Changes

Check out the changes to the Power BI Community announced at Build.

#### Power BI May 2023 Update

Find out more about the May 2023 update.