Forum Discussion
DAX ALL Function not working as expected
Thanks for the idea, but the full table has six different attributes. I can specify them and then explicity specify any dimension tables I link the table to. It really doesn't seem like a sustainable solution, because if I add a new dimension table, I then have to go into the measure (and any measure like it) and add the new dimension table. I guess I'm surprised there isn't a simpler, more straightforward way to just remove a single filter instead of specifying all the filters I don't want removed. I know I can force an average through a calculated column because I can just calculate the average but that's really not best practice either. I'm interested in the proper syntex to unfilter the one column within the measure if it's possibe. Based upon this sqlbi.com article, they certainly do it, but I do not get the expected result at all. Is it because they are removing filters on the related Sales table instead of a filter in the Products table itself?
https://community.powerbi.com/t5/Desktop/Minimum-Date-ALL-does-not-ignore-date-filter-context/m-p/683275
Baffled as to why ALL behaves this way...
Found this thread: Solved: ALL function not working as expected - Microsoft Power BI Community
I guess if your column is sorted by another column you need to have both of them in the all statement
This saved my day. Thank you!
