Find total duration based on virtual filtered table.

Hi Jimmy,

Seems like this could work for me.

I have excluded some data in the miniute level granuality for the sake of simplicity. 

My actual data looks like below. I need duration to calculate when only Avil column is '0'.

This is just a 30min sample only involving only 3 equips only. I have about 150 other type of equips. 

What I am trying here is to get the total duration of area where Avil is '0' based on the orginal explenation. I am using Time Brush to change the time in the report. 

I can email my PBIX file if you want to have a look.

You have been a great help so far.

amaleranda ,

You just need to modify the dax of first table like below:

New Table =
SUMMARIZE (
    FILTER ( 'Table', 'Table'[Avil] = 0 ),
    'Table'[Type],
    "Duration", CALCULATE ( COUNTROWS ( 'Table' ), ALLEXCEPT ( 'Table', 'Table'[Type] ) ),
    "Start", CALCULATE ( MIN ( 'Table'[Time] ), ALLEXCEPT ( 'Table', 'Table'[Type] ) ),
    "End", CALCULATE ( MAX ( 'Table'[Time] ), ALLEXCEPT ( 'Table', 'Table'[Type] ) )
)

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.