Forum Discussion
Distinctcount with Filters
Hello, in this example I'd like to distinctcount the Brand without the filter combination [Category] = NO and ([Day Segment] = Weekday and [Day Segment] = Weekend). Here Brand A, E and G ...
The filter statement in the end looks incorrect!
Change it to,
Filter(Table, OR(AND([Category] = "NO" , [Day Segment] = "Weekend") , AND([Category] = "NO" , [Day Segment] = "Working Day")))
Br,
J