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:

Sean's avatar
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's avatar
sieed
Helper II
9 years ago

Thanks Sean