Forum Discussion

amilecki's avatar
amilecki
Frequent Visitor
9 years ago

SUM Using Slicer Filters

I would like to create a calculated column to determine the sum of values just like an aggregate sum from a visual (chart, matrix, etc).   I've created the following sample data set that mimics my ...
Need Help
amilecki's avatar
amilecki
Frequent Visitor
9 years ago

v-ljerr-msftHow do I get the measure by supplier?  Let me clarify what I am attempting to do.  I am trying to create a new slicer that filters data by the Company's bucket for sum like this.

 

Slicer

0-4

5-8

9-12

>12

 

I thought by creating a calculated column for sum, I could also create a calculated column for bucket using a switch statement.

 

Finally, I thought the Calculate function forces the Sum to recompute for the filters.

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi amilecki,

 

While it doesn't work in that way, an alternative way to filter data by the Company's bucket for sum is to use the [MySum] measure as a visual level filter, instead of using a Slicer.

 

For example, if you want sum from 0 to 4, then you can use [MySum] to apply a visual level filter like below. :smileyhappy:

 

 

Regards