Forum Discussion

ERing's avatar
ERing
Icon for Post Partisan rankPost Partisan
1 year ago
Solved

Calculate <> Not working as expected

I have two simple measures below. I'm trying to show the count of membership status = ACTIVE and the other measure should show the count of membership status = Blank (251) + Expired (7) + Canceled (5...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi @ERing ,

Glad that your query has been resolved. If our community member's response addressed your question, please Accept it as  Answer and click Yes if you found it helpful.

If you have any further questions, feel free to reach out.

Thank you for being a part of the Microsoft Fabric Community Forum!