Forum Discussion
Solved
Measure based on a multi-select slicer
Hi, I'm trying to create a measure that obtains a count of records based on the records listed in the relevant months from the slicer selection. I can get the list of months using Multi_Select...
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
The table I'm using already has a date range on it as it would appear in a seperate table, and is fine for all my other visuals as they are filtered on categories.
I'm creating another visual multi-card that contains a total count of all tasks within the range selected no matter what category they are and then another measure gets the total for the category to then do a percentage.
The measure based on the category within the range is correct, it's the overall I'm having an issue with