Forum Discussion
SUM Using Slicer Filters
Hi amilecki,
Not like measures, calculate columns/tables are computed during database processing(e.g. data refresh) and then stored in the model, they do not response to user selections on the report.
So it is not possible to create a calculate column/table can change dynamically with user selections on the report.
In this scenario, you can create a measure to calculate the sum of values instead, then show the measure on the Table/Matrix visual with the corresponding columns from your table. The formula below to create the measure is for your reference. :smileyhappy:
MySum = SUM('MyData'[Value])
Regards
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.
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
v-ljerr-msftThis works for me in the desktop version although breaks up the useability. When I publish to the web, will other users be able to modify the filter values?
