cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## 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];
"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.

1 ACCEPTED SOLUTION
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

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.