How to create a dynamic sum filter?

[Anonymous]

Greetings,

I have this problem encoutered recently; the filter is only filtering by single dates, whereas I would like to filter it as a sum of dates: 

This is the actual chart with all dates combined: 

This is the granular column I would like to combine together: 

[v-jayw-msft · Accepted solution]

Hi @Anonymous ,

You could create numeric range slicer instead of using filter.

Using MAX() and MIN() function to get the start and end range.

Then create a measure like below to get value in this range.

calculate([value],filter(all(table),column>=min(slicervalue)&&column<=max(slicervalue)))

Best Regards,

Jay 

[negi007]

@Anonymous You can create a column to group multiple items and then use this colum to filter values. Grouping could be month, week, quarter or anything else which can specifiy.