Summarize grouping by 2 columns

Hi Anonymous ,

You can create below 2 calculated columns and a calculated table to achieve it:

1. Create calculated columns to get the date and hour

Date = DATE(YEAR('Table'[INIZIO]),MONTH('Table'[INIZIO]),DAY('Table'[INIZIO]))

Hour = HOUR('Table'[INIZIO])

2. Create a summary table

Summary = 
SUMMARIZE (
    'Table',
    'Table'[Date],
    'Table'[Hour],
    "Nr op", CALCULATE (
        DISTINCTCOUNT ( 'Table'[MATRICOLA] ),
        FILTER (
            ( 'Table' ),
            DATE ( YEAR ( 'Table'[INIZIO] ), MONTH ( 'Table'[INIZIO] ), DAY ( 'Table'[INIZIO] ) ) = 'Table'[Date]
                && HOUR ( 'Table'[INIZIO] ) = 'Table'[Hour]
        )
    ),
    "Nr contenitori", CALCULATE (
        COUNT ( 'Table'[CONTENITORE] ),
        FILTER (
            ( 'Table' ),
            DATE ( YEAR ( 'Table'[INIZIO] ), MONTH ( 'Table'[INIZIO] ), DAY ( 'Table'[INIZIO] ) ) = 'Table'[Date]
                && HOUR ( 'Table'[INIZIO] ) = 'Table'[Hour]
        )
    )
)

Best Regards

Rena