Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Counting Active Processes

I want to create a calculated table or measure or visual which takes in a date and returns the count of the amount of processes which were in progress on that date.   For example:   Process s...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    I managed to get this to work how I wanted it to.

     

    the table on the left is named ExampleData.

     

    First I created a table of times from the data:

     

    TimeTable = GENERATESERIES(MIN('ExampleData'[start time]),MAX('ExampleData'[end time]))
     
    Then I used the following measure :
     
    ActiveProcesses =
    var MaxTime = MAX('TimeTable'[Value])
    var MinTime = MIN('TimeTable'[Value])
    RETURN
    CALCULATE(COUNT('ExampleData'[Process])+0,
    MaxTime >= 'ExampleData'[start time],
    MinTime <= 'ExampleData'[end time])
     
    Then I am able to plot 'Timetable'[value] against ActiveProcesses for the desired effect.
Anonymous's avatar
Anonymous
Not applicable
3 years ago

It works, but it's not exactly what I was hoping for; the approach lacks flexibility.

It feels like a workaround to make what I'm trying to do work with equalities, but the workaround requires multiplying the sizes of tables. I would be going from 10,000s of rows to millions.