Help with "ALL" in a Matrix

[setis]

Dear experts,

I am struggling trying to use ALL in a measure in my matrix:

My column hierarchy looks like this:

The desired result is 1139 on all the cells for the second row (the total nr of cases for the selected week)

I've tried a lot of different things. The last attempt:

NrCasesForecastedThisWeekALL =
CALCULATE (
    [# Cases Forecast -NoSL];
    ALL ( 'Date'[WeekDayNumber]; 'Date'[Week Day]; 'Date'[Date] )
)

With this I'm getting the same result as you can see above. 

I have tried this as well

AllCases = CALCULATE([# Cases -NoSL] ; ALLEXCEPT('Date';'Date'[Calendar Week]))

but the result is not correct. 

Thank you in advance!

[AlB]

Hi @setis 

Can you show the code for the measure and perhaps the structure of the tables involved, including relationships? To start with, wouldn't you need an ALL on 'Date'[Calendar week] as well? 

NrCasesForecastedThisWeekALL =
CALCULATE (
    [# Cases Forecast -NoSL];
    ALL ( 'Date'[WeekDayNumber]; 'Date'[Week Day]; 'Date'[Date];'Date'[Calendar Week] )
)

[setis · Accepted solution]

Dear @AlB Thanks a lot for reaching out 🙂

The measure is a simple DISTINCTCOUNT for IDs.

I actually made it work like this:

CALCULATE([# Cases Forecast -NoSL] ; ALLEXCEPT('Date'; 'Date'[Calendar Week] ; 'Date'[Calendar Year]))

I was using a slicer for the calendar year in the page and that had to be included in the measure. 

Thanks for your quick response!