Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Average Count by hours

Hi,   New to PBI and wondering how I can calculate the average number of cases by hour. Data is a list of cases and I've created a measure Count = countrows(Incident). Through this I can see the nu...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    hi Anonymous

     

    try with this:

     

     

    Avgxhora =
VAR HoraCreacion =
    FIRSTNONBLANK ( Table1[Hora Creación], Table1[Hora Creación] )
RETURN
    DIVIDE (
        CALCULATE ( COUNTROWS ( Table1 ), ALLEXCEPT ( Table1, Table1[Hora Creación] ) ),
        COUNTROWS (
            SUMMARIZE (
                FILTER ( ALL ( Table1 ), Table1[Hora Creación] = HoraCreacion ),
                Table1[Hora Creación],
                Table1[Mes Creación]
            )
        )
    )
Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

hi Anonymous

 

try with this:

 

 

Avgxhora =
VAR HoraCreacion =
    FIRSTNONBLANK ( Table1[Hora Creación], Table1[Hora Creación] )
RETURN
    DIVIDE (
        CALCULATE ( COUNTROWS ( Table1 ), ALLEXCEPT ( Table1, Table1[Hora Creación] ) ),
        COUNTROWS (
            SUMMARIZE (
                FILTER ( ALL ( Table1 ), Table1[Hora Creación] = HoraCreacion ),
                Table1[Hora Creación],
                Table1[Mes Creación]
            )
        )
    )
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Vvelarde

 

That is absolutely fantastic, thank you very much for taking the time to help me with this one, it worked perfectly.

 

I need a lot more practice with this it seems :)

 

Saludos,

 

Matt