Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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

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?

Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    6 years ago

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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