Using hours as a conditional value - countrows betweens hours

[alexandrecr]

Hi,

I am a PBI newbie. But first of all, I have this table:

ASUMMA = 
SUMMARIZE (
    'RELATÓRIOS';
    'RELATÓRIOS'[Tripulante]; 'RELATÓRIOS'[Cargo Tripulante]; 
RELATÓRIOS'[DATA.Partida Prevista]; 'RELATÓRIOS'[DATA.Chegada Prevista]; 'RELATÓRIOS'[Sumarizado.Acerto de Contas];
    "Hora Chegada"; MAX ('RELATÓRIOS'[HORA.Chegada Prevista] );
    "Hora Partida"; MIN ('RELATÓRIOS'[HORA.Partida Prevista]))

Column "Tripulante" have names; colomn "DATA.*" have dates and "HORA.*" have hours (HH:mm:ss).

I want a new measure like COUNTROWS (maybe) that counts how many rows I have in HORA columns that matches between a specific hour, something like:

MEASURE = COUNTROWS ( FILTER ('ASUMMA';'ASUMMA'[Hora Chegada] < 17:00:00))

But this is not working.

[v-juanli-msft · Accepted solution]

Hi @alexandrecr

As tested, you could try this measure

Measure = CALCULATE(COUNT(Sheet6[hour.c]),FILTER(ALL(Sheet6),[hour.c]<TIME(17,00,00)))

Or 

Measure 3 = COUNTROWS(FILTER(ALL(Sheet6),[hour.c]<TIME(17,0,0)))

Best Regards

Maggie