Measure - Countif <= Date

Hi Anonymous ,

Is that you want to calculate how many days are there depend on Min work center?

the results of two centers are same due to  the function ALL(), it remove all the filter, so the result is the same. my solution is add more detail for the filter.

Try the following expression:

AgeGT14Days =
COUNTROWS(
    FILTER(
        ALL( 'AssetManagement Open_N2' ),
        'AssetManagement Open_N2'[Created on]
            < TODAY() - 14
            && [Min work center] = MAX( 'AssetManagement Open_N2'[Min work center] )
    )
)

If i misunderstood what you want, please let me know.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.