Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 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
    6 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
6 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)

al4xs's avatar
al4xs
New Member
1 year 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! 😄