Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 get...
DAX
REMOVEFILTERS
  • wdx223_Daniel's avatar
    wdx223_Daniel
    5 years ago

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

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

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
5 years ago

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