Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Using hours as a conditional value - countrows betweens hours

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.

  • Hi Anonymous

    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

1 Reply

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support

    Hi Anonymous

    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