all selected () unexpected behavior

[amitchandak]

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]))
)

[amitchandak]

Forgot table in filter

cumulated hours =
CALCULATE(
[Hours] ,
ALLSELECTED( 'calendar' ), filter('calendar','calendar'[week num] <=max('calendar'[week num]))
)

Appreciate your Kudos.

[v-eachen-msft]

Hi @bbbt123 ,

Your formula seems to be correct, maybe it is a data issue?

Please check if your No.11 week's data is correct. Or is the "Hours" column determined by the calculation formula?