Forum Discussion
all selected () unexpected behavior
If you want cumulative
This need row context to need to be in filter and in max
cumulated hours =
CALCULATE(
[Hours] ,
ALLSELECTED( 'calendar' ), filter('calendar'[week num] <=max('calendar'[week num]))
)
Forgot table in filter
cumulated hours =
CALCULATE(
[Hours] ,
ALLSELECTED( 'calendar' ), filter('calendar','calendar'[week num] <=max('calendar'[week num]))
)Appreciate your Kudos.