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 Pre...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    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

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

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