Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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 
 
GuiGentil_0-1645204323265.png

 

 

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?

 

GuiGentil_1-1645204430371.png

 

 

The corret is 31% not 7 %

 

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

 

1 ACCEPTED SOLUTION
Russell-PBI
Resolver II
Resolver II

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.

View solution in original post

3 REPLIES 3
v-robertq-msft
Community Support
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?

 

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
Not applicable

Yes I did, already selected as a solution

Russell-PBI
Resolver II
Resolver II

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors