Forum Discussion
Solved
Sum ignoring filter
Hi, sorry for very easy thing for you but I have a question. In order to create some graph, I would like to make an expression of "sum ignoring filter". For example, in the case as below, even i...
I can see you are ignoring all the dates, you want to ignore the column that you are using on the slicer ?
If yes, it's something like:
CALCULATE(SUM(TABLE[COLUMN]), ALL(TABLE[COLUMN_USED_ON_SLICER]))
I can see you are ignoring all the dates, you want to ignore the column that you are using on the slicer ?
If yes, it's something like:
CALCULATE(SUM(TABLE[COLUMN]), ALL(TABLE[COLUMN_USED_ON_SLICER]))
