Date filter

Tcounihan · ‎10-27-2021

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,

v-jingzhang · ‎11-01-2021

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.

KNP · ‎10-27-2021

Yes it is.

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.