Forum Discussion

sieed's avatar
sieed
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...
Need Help
  • Sean's avatar
    Sean
    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:

parry2k's avatar
parry2k
Super User
9 years ago

Since he already have IsFinished flag, no need to calculate a measure assuming each job will have one record:

 

- Put date on the axi

- IsFinished on legent

- Cound Job Id on value 

 

and it will do the job, no?

sieed's avatar
sieed
Helper II
9 years ago

parry2k, I am trying to find the ditinct count of "finishNumber" based on whether a task is completed or not for that particular date. 

 

For instance, on 3/12017, I have three tasks, two of which are complete. Moreover, these two completed tasks have different "finishNumber".  so, the distinct count should be 2 on the tool tip. Also, for the same bar on the same date, the black area (the area representing the record which is not complete) should show distinct count of zero since there is no "FinishNumber" for that record.