ALLEXCEPT not ignoring filters

Ultimately I am building a measure that looks like this: CALCULATE(SUM(Table[Amount]), FILTER(ALLEXCEPT(Table, Table[Project]), Table[Date] <=SELECTEDVALUE(Table[Week]))) This calculates a JTD ...

Need Help

az38

6 years ago

@hahl

Yes, exactly. wrong copy and paste 😞

Measure = 
var _endDate = CALCULATE(MAX('CalendarTable'[Date]))
RETURN
CALCULATE(SUM('Table'[Amount]),FILTER(ALLEXCEPT('Table','Table'[Project]),'Table'[Date]<= _endDate ))

Безымянный.png

Forum Discussion

ALLEXCEPT not ignoring filters

Related content

Filtering with ALLEXCEPT()

Filter and Allexcept

Make measure ignore specific filter

Ignore filter for a measure

Filter with ALLEXCEPT