Forum Discussion

Helper II

9 years ago

Solved

Help with Distintcount logic

I have the following table: This table is basically capturing whether a job is finished or not. I am displaying the job vs date graph below: In this graph, I would like to...

9 years ago

Distinct Count Measure =
CALCULATE (
    DISTINCTCOUNT ( 'Table'[finishNumber] ),
    FILTER ( 'Table', 'Table'[finishNumber] <> BLANK () )
)
    + 0

Add plus zero - it just forces the zero to show! :smileyhappy:

Community Champion

9 years ago

Use my Measure from above in the Tooltips!

It will show up only for true!

Helper II

9 years ago

Sean, what do I do if I also want to diaply the distincount of 0 ?

Sean
Community Champion
9 years ago
Distinct Count Measure = CALCULATE ( DISTINCTCOUNT ( 'Table'[finishNumber] ), FILTER ( 'Table', 'Table'[finishNumber] <> BLANK () ) ) + 0
Add plus zero - it just forces the zero to show! :smileyhappy:
- sieed
  Helper II
  9 years ago
  Thanks Sean
- parry2k
  Super User
  9 years ago
  sieed what I mentioned will work, make sure you have IsFinished on Legend. No sure why there is a need to calculate a measure when you already have IsFinished to seperate between finished and non-finished jobs. Also it is assuming that you will unique finish number. It is always good to provide little context about the dataset so that better solution can be provided.
  
  THanks,
  - Sean
    Community Champion
    9 years ago
    parry2kWhat do you propose we drag to the tooltips? And how will you make it show zero on False?
    
    And BTW my measure would work with COUNTA not only DISTINCTCOUNT because EACH Column represents an APP
    
    However here's why I used DISTINCTCOUNT - this is from the original question...
    "the distinct count of finishNumber for the two completed tasks should be 2 ( since 14 and 16 are distinct)"