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

sieed

This is what I would do...

Create this Measure (you can rename it something better)

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

And then setup your Chart like in the picture below

Date on Axis, AppID in the Legend, Measure in the Value

(right-click on AppID in the Legend as check - Show Items with No Data)

Hope this helps! :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?