Forum Discussion
DAX : Filter issue
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
thank you
off course it's possible to use a matrix, like we do in Excel.
But what I want is create a measure TotalSalesExceptOthers, and this measure will be used in differents visualisations, such as
basic-area-chart https://support.powerbi.com/knowledgebase/articles/653149-tutorial-basic-area-chart
and for creating other measure. for example the rate : SalesExceptOthers/TotalSales etc
It is a basic request : i guess everybody wants to have a filtered measure (in order to exclude data). But CALCULATE(SUM('Table1'[Sales]);FILTER(ALL('Table1'[RevenueType]);'Table1'[RevenueType]<>"others")) is a cumulative formula
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