Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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)
Solved! Go to Solution.
Hi @Osmanakgunduz ,
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! 🙂
Proud to be a Super User!
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:
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:
Hi @Osmanakgunduz ,
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! 🙂
Proud to be a Super User!
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
100 | |
97 | |
72 | |
68 |