Measure include only one filter

[happyfeet992]

Hi,

I have an issue with one measure and filtering. 

In my table I have four columns: BatchId, Date, Qty, Color.

I have slicer for Color and Date. I need to prepare measure where I include only one filter (Date for all colors) - how can I do that without edit interactions? I've tried to use some filters in CALCULATE function but it doesn't work 😞

Could you help me?

[jppv20 · Accepted solution]

Hi @happyfeet992 ,

Not sure if I understand the question correctly, but have you tried 

ALLEXCEPT('Table','Table'[Date])

If I answered your question, please mark it as a solution to help other members find it more quickly.