Forum Discussion
Post PartisanCalculate <> 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) + Deleted (1).
I can see from my donut chart that the count <> Active should be 264, however the measure is returning 257.
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.
11 Replies
- lbendlin
Super User
what's the definition of [Total_Customers] ?
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.
- Bibiano_Geraldo
Hi ERing ,
I just wanted to kindly follow up to see if you had a chance to review my previous response. Please let me know if it was helpful, and feel free to reach out if needed any further assistance. If yes, please Accept the answer so that it will be helpful to others to find it more quickly.Thank you.
Hi ERing ,
Glad that your query has been resolved. If our community member's response addressed your question, please Accept it as Answerand click Yes if you found it helpful.
Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!
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!
