Forum Discussion
Solved
DAX : Filter issue
Hi everyone, I want to filter a field. For example, Total sales for every month except June What I did : CALCULATE(SUM('Table1'[Sales]);FILTER(ALL('Table1'[Month]);'Table1'[Month]<>"June")) ...
Do you need to use FILTER ?
This works for me. And it ignore filters when made
Sales14 = CALCULATE(sum (SalesDetail[Sales Value £]), CalendarInv[Year] = 2014)
whereas using if doesn't. And filter doens't as well
Depends how you use the filters in order to be a cumulative formula.Try not to use ALL inside FILTER..
yes thanks RJ and konstantinos
Without using FILTER, it is not cumulative
so my formula becomes
CALCULATE(SUM('Table1'[Sales]);'Table1'[RevenueType]<>"others"))