Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
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.
Solved! Go to Solution.
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
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
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
72 | |
67 | |
65 | |
42 | |
42 |
User | Count |
---|---|
46 | |
38 | |
28 | |
26 | |
26 |