Forum Discussion
Measure based on a multi-select slicer
Thanks all,
Managed to resolve it using the month table with the count of measure entries, I created another card that just used this and summed the values up for the selected months
I've created a table for the dates to choose (to confirm it has no bearing on the issue), along with the totals for each month
| Month | Total |
| 1/1/2022 | 55 |
| 1/2/2022 | 145 |
| 1/3/2022 | 543 |
| 1/1/2023 | 7 |
| 1/10/2021 | 15 |
| 1/11/2022 | 325 |
The user can select mutliple dates from the range using a splicer and not in sequential format, so may choose 1/1/2022, 1/3/2022, 1/11/2022
I need to be able to add the totals for each month to get an overall figure which should be 55 + 543 + 321 = 919
But what happens is that I get blank as it only works for one month, i can't use other formulas as it seems to add everything that occurs between the min and max date
You could use TREATAS with your date slicer table
Total = CALCULATE( COUNTROWS(TaskRange), TREATAS( VALUES('Month Slicer'[Month]), TaskRange[Month]) )
