Calculate <> Not working as expected

Hi ERing ,

Thank you for reaching out to the Microsoft Fabric Community Forum regarding the issue you're facing.

After reviewing the screenshots provided, I attempted to replicate the issue locally, and everything appears to be working as expected. For your reference, I’m providing a document that may help you.

Additionally, please consider the following suggestions:

• Ensure that no additional filters are applied to your visual or report, as they might unintentionally exclude some rows.
• Double-check that the status values in your data precisely match the strings used in your DAX formula
   

I hope this helps resolve your issue. If so, kindly give us Kudos and consider marking this post as the solution to assist other members in finding the answer more quickly.