Calculate <> Not working as expected

[ERing]

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.

[v-pagayam-msft]

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!

[v-pagayam-msft]

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!

[v-pagayam-msft]

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.

[danextian]

Hi @ERing 

How did you calculate Total Customers? Did you use DISTINCTCOUNT on a column? If so, it is possible that there are distinct values in that column with more than one statuses.

[Bibiano_Geraldo]

Hi @ERing ,

Can you please share no sensitive file to see the issue closer?

[v-pagayam-msft · Accepted solution]

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.

[lbendlin]

what's the definition of [Total_Customers] ?

[ERing]

The definition of [Total_Customers] is the count of ID from my customer table.

[lbendlin]

how are the tables related?

[ERing]

The tables are not related in my model.

[lbendlin]

Quite impressive that you get any results at all then.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...