occurrence
1 Topic
Occurrence by day with Summarizecolumns
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.Solved1.1KViews0likes2Comments