Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

ALL functions not working

Hello,   I have a simple DAX formula that includes ALL functions. It works with different tables but does not in a specific table. Can anyone help me? I want to make the month number filter inactiv...
Need Help
  • JarroVGIT's avatar
    JarroVGIT
    6 years ago

    Hi Anonymous ,

    I recently found out that ALL() does not remove filters that are set bij the Filter pane. It will only remove filters applied within queries and slicers. 

    At the time I found this weird behaviour too, but to be honest the filterpane is there for your end users to interact with as well (or not, depends on your settings) and it would be strange that when you set a page or report filter, you can actually override that filter with DAX.

    Hope this clarifies this issue for you!

     

    Kind regards

    Djerro123

    -------------------------------

    If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

    Keep those thumbs up coming! 🙂

  • Anonymous's avatar
    Anonymous
    6 years ago

    Hello JarroVGIT  again. 

     

    I found that it is not about slicer or filter pane. It is about measure formula. I will try to explain in order to help others that meet with this issue.

     

    if your formula contains a variable, it works. for example: 

    All Revenues = CALCULATE([Revenue];ALL('Date'))
     
    but if your formula is like:
    All Revenues 2 = CALCULATE(SUM(GENERALJOURNALACCOUNTENTRY[ACCOUNTINGCURRENCYAMOUNT]);ALL('Date'))
    It doesn't work. 
     
    Best Regards.
JarroVGIT's avatar
JarroVGIT
Resident Rockstar
6 years ago

Hi Anonymous ,

I recently found out that ALL() does not remove filters that are set bij the Filter pane. It will only remove filters applied within queries and slicers. 

At the time I found this weird behaviour too, but to be honest the filterpane is there for your end users to interact with as well (or not, depends on your settings) and it would be strange that when you set a page or report filter, you can actually override that filter with DAX.

Hope this clarifies this issue for you!

 

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thank you JarroVGIT  You are great!