Forum Discussion

Tcounihan's avatar
Tcounihan
New Member
4 years ago

Date filter

Hello, 

 

I have a 'case open date' filter applied to my sheet 

 

I am wondering if it is possible to create a measure that counts all cases opened prior to the filtered dates? 

 

Thanks, 

Need Help
Tutorial Requests

2 Replies

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    4 years ago

    Hi Tcounihan 

     

    You could use ALLEXCEPT or ALL function in your measures. For example, the following measure will count id on all case open dates and ignore the 'case open date' filter.

    measure_count = CALCULATE ( COUNT ( 'table'[id] ), ALL ( 'table'[case open date] ) )

     

    However, if you replace ALL with ALLEXCEPT, it will count id on filtered case open dates and ignore filters on other potential columns. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.