Forum Discussion
Removefilters not working
Hi All,
I'm writing a DAX Query which exectutes different parts of the query depending on the current filter. This logic works, however:
In example #1, de removefilters works just fine. I'm getting values over a range of dates.
In example #2, the removefilters does not work. The result is a value on a single date.
It seems to be caused by the filter statement which i marked with as #3. Does anyone know if performing a removefilter together with another filter in the Calculate statement does't work? I can imagine the fact table inside #3 is still filtered by the date table. But how to get rid of the Date filter there?
I've tried to work with ALLEXCEPT(FACT,COLUMN,ETC). But so far no result.
Any help is appreciated.
Anonymous try to add another CALCULATE out of your code and move REMOVEFILTERS outside, such as
IsLevelDfiltered=CALCULATE(CALCULATE(SUM,FILTER,DATEBETWEEN),REMOVEFILTER)
6 Replies
Anonymous try to add another CALCULATE out of your code and move REMOVEFILTERS outside, such as
IsLevelDfiltered=CALCULATE(CALCULATE(SUM,FILTER,DATEBETWEEN),REMOVEFILTER)
This works, but why? I would think it would remove the filter in the inner Calculate also, but it doesn't.
thanks so much for this, was bashing my head against a wall wondering why something so simple wasnt working!
if anyone can explain why this works that would be great!
I created an account to write this reply! 😄
Hi Anonymous
By using the whole table 'Transformatie Dim_HoldingDate' as base for the FILTER( ) in #3, you are basically "bringing back in" whatever filter context is active on that table. If you are only filtering on the [NODE_NO] column, you can better use:
FILTER( ALL('Transformatie Dim_HoldingDate'[NODE_NO]), 'Transformatie Dim_HoldingDate'[[NODE_NO] = RELATED(.....))
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
