Forum Discussion

mmorley's avatar
mmorley
Frequent Visitor
4 years ago
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...
Need Help
  • mmorley's avatar
    mmorley
    4 years ago

    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

     

johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago

Set up a proper date table and link that to your TaskRange table. Use columns from the Date table on your visuals, including the slicer, and your measure becomes simply

Total tasks = COUNTROWS( 'TaskRange')