Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 ye...
Need Help
Show and Tell
Tips and Tricks
  • Russell-PBI's avatar
    Russell-PBI
    4 years ago

    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.

Russell-PBI's avatar
Russell-PBI
Resolver II
4 years ago

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.