Can this be done using a measure? I have one than sums up the hours. I also have week number in my date table. In my matrix visual, I have employee as row and week as column. I then apply the filter hours < 40. It works when I select only one week in the slicer. I see all employees whose total hours in the selected week is less than 40. But if I add a second selected week in the slicer, the filter gets applied to the total for the 2 selected weeks. The filter is like total hours for 2 weeks < 40. How can I make the filter be checked against each individual week’s total? I want it to work even if I select multiple weeks.
With 1 week selected
With 2 weeks selected, filter of <40 is being applied to total of the 2 weeks. I want it to be applied to each individual week’s total.
Best regards,
Ferdinand