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 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.

 

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.

3 Replies

  • 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.

  • v-robertq-msft's avatar
    v-robertq-msft
    Community Support
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      Yes I did, already selected as a solution