topic Re: Removefilters not working in DAX Commands and Tips

Removefilters not working

Anonymous — Wed, 11 Nov 2020 19:52:13 GMT

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.

Re: Removefilters not working

AlB — Wed, 11 Nov 2020 21:37:35 GMT

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

Re: Removefilters not working

Anonymous — Thu, 12 Nov 2020 07:42:59 GMT

Hi AlB,

I'm not using the holdingdate in the Filter in #3, did you accidently read it wrong, or do I misunderstand you?

Re: Removefilters not working

wdx223_Daniel — Thu, 12 Nov 2020 08:03:28 GMT

Anonymous try to add another CALCULATE out of your code and move REMOVEFILTERS outside, such as

IsLevelDfiltered=CALCULATE(CALCULATE(SUM,FILTER,DATEBETWEEN),REMOVEFILTER)

Re: Removefilters not working

Anonymous — Thu, 12 Nov 2020 08:46:06 GMT

Thanks Daniel! Works like a charm! 🙂

Re: Removefilters not working

RobertStiekema — Tue, 07 Nov 2023 15:11:39 GMT

This works, but why? I would think it would remove the filter in the inner Calculate also, but it doesn't.

Re: Removefilters not working

al4xs — Thu, 06 Nov 2025 09:48:08 GMT

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! 😄