Forum Discussion
DAX Measures ALL, REMOVEFILTERS
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
6 Replies
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.
Try replacing the ALLSELECTED on Year and month name, and the ALL on week number, with ALLEXCEPT(DimDate, DimDate[CalendarYear], DimDate[Albanian Month Name])
