Forum Discussion
bbbt123
Helper I
Helper Iall selected () unexpected behavior
amitchandak
Super User
Super UserIf 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]))
)
bbbt123Helper I
Helper I
- bbbt123
- amitchandak
Forgot table in filter
cumulated hours =
CALCULATE(
[Hours] ,
ALLSELECTED( 'calendar' ), filter('calendar','calendar'[week num] <=max('calendar'[week num]))
)Appreciate your Kudos.
- bbbt123