Forum Discussion
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 inactive, but not working. I tried REMOVE FILTERS too but got the same result. Thanks.
(I added two screenshots that show different amount, the amount must be same and total amount of all months and years)
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! 🙂
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.
3 Replies
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! 🙂
Thank you JarroVGIT You are great!
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.