Measure not filtered with the filter pane

[Syndicate_Admin]

Hello everyone

I have the following measure:

Closed projects = CALCULATE(DISTINCTCOUNT('Project Report'[PROJECT]),'Project Report'[Status]="CTEC"||' Project Report'[Status]="CERR")

When you filter the CTEC and CERR states in the filter pane, that measure should mark zero, but it does not currently do so.
Is the measure wrong?

Thanks a lot

[v-kkf-msft · Accepted solution]

Hi @Syndicate_Admin ，

Try the following formula:

Closed projects = 
CALCULATE(
    DISTINCTCOUNT('Project Report'[PROJECT]),
    FILTER(
        ALLSELECTED('Project Report'),
        'Project Report'[Status] = "CTEC"
            || 'Project Report'[Status] = "CERR"
    )
)

If you just select in the visual level filter, it will only affect the results displayed by this visual, and will not affect other visuals. Therefore, you need add the Status field to the visual level filter that displays the measure or to the page level filter.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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