Calculate(DistinctCount()) - Counts wrong (sometimes)

[Anonymous]

Hi all,

I am dealing with a problem of Calculate(DistinctCount()).

Each Row/Project has a "Phase". If I want to specifically count the rows/projects that has "11. Lost" then I get 1 less than the actual count (I have checked my table for the exact count).

What I don't understand is that some of the "Phases" actually gets counted right like "7. Sold" as seen below:

What am I doing wrong?

[Anonymous · Accepted solution]

Their must be duplicate entry in the Data.

So while showing the count in the graph it is showinh 11.

But in measeure column you have used distinct so its considering duplicate entry as 1. so its showing you count as 10.

Use the right function as per your need. try with 

COUNTX