cancel
Showing results for
Did you mean:

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors