Occurrence by day with Summarizecolumns

[soldous]

Hi there,

I have a measure to calculate the occurrence when a shift is longer than 6 hours:

Occurrence = COUNTX (
        FILTER (
            SUMMARIZECOLUMNS (
                Timekeeping_Data[Date],
                Timekeeping_Data[SHIFT_ID],
                Timekeeping_Data[FirstName],
                "shift", DATEDIFF([FistDayStart],[FistBreakStart],MINUTE)/60
            ),
            [shift] > 6
        ),
        Timekeeping_Data[FirstName]
    )

It works fine when I put the measure to the card visual and also when I filter the whole page by Timekeeping_Data[Date] but when I want to create the occurrence by date using the bar chart I'm receiving the error:

SummarizeColumns() and AddMissingItems() may not be used in this context.

Could someone help me with modifying the measure to be used in the bar chart per day?

Thanks a lot.

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your dataset looks like, but please try something like below.

Occurrence =
COUNTX (
    FILTER (
        ADDCOLUMNS (
            SUMMARIZE (
                Timekeeping_Data,
                Timekeeping_Data[Date],
                Timekeeping_Data[SHIFT_ID],
                Timekeeping_Data[FirstName]
            ),
            "@shift", CALCULATE ( DATEDIFF ( [FistDayStart], [FistBreakStart], MINUTE ) ) / 60
        ),
        [@shift] > 6
    ),
    Timekeeping_Data[FirstName]
)

[soldous]

That's it.

Thanks a lot"