Forum Discussion
How to create a dynamic sum filter?
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...
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
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