Forum Discussion
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...
Distinct Count Measure = CALCULATE ( DISTINCTCOUNT ( 'Table'[finishNumber] ), FILTER ( 'Table', 'Table'[finishNumber] <> BLANK () ) ) + 0Add plus zero - it just forces the zero to show! :smileyhappy:
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?
Use my Measure from above in the Tooltips!
It will show up only for true!
