Forum Discussion
Cumulative Sum wrong when using visual filter
Your ALL is overriding your slicer in the context of the calculation. That's what ALL does. If you want to preserve your filtering in your report, you need to use ALLEXCEPT and in the ALLEXCEPT arguments you need to specify your slicer column.
The issue is likely your ALL in your filter clause. You probably need to use ALLEXCEPT.
I am not sure how can I use ALLEXCEPT instead of ALL in this case?!
Just to add, it does not matter what value I set in filter. It could be 200% (literally all products), but the behaviour is the same like for 30% or 50% or 70%.
As long as filter is present, value is wrong for some rows.
Important thing may be that I don't have that column in dimension. It is in fact table. I may try to move it , to create dimension, although there are some issues to do so (dirty data, additional preparation).
Your ALL is overriding your slicer in the context of the calculation. That's what ALL does. If you want to preserve your filtering in your report, you need to use ALLEXCEPT and in the ALLEXCEPT arguments you need to specify your slicer column.
Hi an thanks!
I accepted your solution since it has logical and valuable explanation one should take into account any time writing DAX formulas. But I solved it differently, through the model. I just moved slicer column to the dimension.
Basically, I got one huge Excel file with dimensions and facts all in one table (i.e. Excel sheet). But when I created artificial dimension, with SUMMARIZECOLUMNS, things got better.
