Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. 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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
92 | |
86 | |
85 | |
66 | |
49 |
User | Count |
---|---|
140 | |
113 | |
106 | |
64 | |
60 |