Forum Discussion

happyfeet992's avatar
happyfeet992
New Member
4 years ago
Solved

Measure include only one filter

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?

Need Help
  • jppv20's avatar
    jppv20
    4 years ago

    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.

1 Reply

  • jppv20's avatar
    jppv20
    Solution Sage
    4 years ago

    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.