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)

wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
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)

  • RobertStiekema's avatar
    RobertStiekema
    Regular Visitor
    2 years ago

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

  • al4xs's avatar
    al4xs
    New Member
    9 months ago

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