DAX Measures ALL, REMOVEFILTERS

[Anonymous]

Greetings.

I have a filter slicer with year, month and week number of year.
From a week selection (lets say 38 which is a week in September) I need a visual to show all the applications made in that month.
If I select a week in August I want all applications made in August regardless of the week.

This is for September, week 38

I've used ALLSELECTED to keep the filter coming from the year and the month, but I want to remove filter from the weeknumberofyear.

Yet it doesn't work.

I have tried REMOVEFILTERS as well to weeknumber column but it is not working.
Can you share some thoughts?

Thank you

[Anonymous · Accepted solution]

Instead of a hierarchical slicer We created 2 slicers, one having year and month, and the other having weeknumber of year.
The 2nd slicer does not affect total monthly applications after we modified in Edit Interactions

[Anonymous]

Below is the DAX Code generated by Performance Analyzer

[johnt75]

Its possible that another column correlated to the week number is being added to the filter context. Use Performance Analyzer to copy the DAX code generated for the visual and examine it in DAX Studio, that should tell you which columns are being used as filters and which are being used in the calculation.

Its particulalry common for additional filters to be added with fields from a date table, as lots of columns are sorted by another column, and those sort by columns are also included in the results.

[Anonymous]

This is the DAX Code generated.

I'm not sure if this dimdate[Order] is causing the issue or something else.

I added 

REMOVEFILTERS(Dimdate[Order]) 
But it didn't resolve the issue.

[johnt75]

Try replacing the ALLSELECTED on Year and month name, and the ALL on week number, with ALLEXCEPT(DimDate, DimDate[CalendarYear], DimDate[Albanian Month Name])

[Anonymous]

Still it doesn't work.

I cant get rid of the weeknumber filter.