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.
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.