Forum Discussion
Remove Filters Not working with Date Slicer
Ok, found the issue. It's called Auto Exist, which I don't know anything about. But since I was working within my Calendar table, it wasn't working. When I made a second small table with the month names and connected it to my Calendar table, then it worked!
Of course, then I found this PowerBI post here, that I wish I'd seen earlier: https://community.fabric.microsoft.com/t5/Desktop/DAX-REMOVEFILTERS-Issues/td-p/2834453#:~:text=If%20it%20is%20caused%20by%20auto%2Dexist%20the,way%20to%20create%20a%20dimension%20table%20is.
Hi William,
Firstly, I don't know where you heard that sorting your columns may mess with REMOVEFILTERS but I've never seen that happen and cannot think of any reason why it would.
Secondly, there will always be twelve months in a year so why do you need a measure at all instead of just using 12 wherever you would use this measure?
----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)
P.S. Need a more in-depth consultation for your Power BI data modeling or DAX issues? Feel free to hire me on Upwork or DM me directly on here! I would love to clear up your Power BI headaches.
Thanks for the input, Wilson! As far as the sort order, I agree it seems unlikely, but this article here https://www.sqlbi.com/articles/side-effects-in-dax-of-the-sort-by-column-setting/ made me a bit suspicious so I thought I would at least remove that possibility.
As to the 12 months--my actual formula is taking the month number (Max of month number). I just did the sample formula as a simple test. But probably should have clarified a bit.