Slicer only affecting columns (not lines) on line and clustered column chart

[HM615]

Hello, 

My PowerBI skills are fairly basic so apologies if this query sounds like a child wrote it! I have a line and clustered column chart visual showing the numbers of people who 'released' on a particular day (column) and the cumulative total of people 'releasing' (line). I have a slicer that is supposed to filter this data according to the department these people are in. For some reason, the slicer is filtering the columns (the daily totals) but not the line (the running total). I want it to filter both! The daily and cumulative totals are both measures from the same data table. I can't work out why the slicer affects one but not the other. Any suggestions? 

[amitchandak · Accepted solution]

@HM615 , if you are using all in cumulative like in given example filter will not pass

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(all('Date'),'Date'[date] <=max('Date'[date])))

Cmm Based on Date = CALCULATE([Net], Window(1,ABS,0,REL, ALL('date'[date]),ORDERBY('Date'[date],ASC)))

But you can use allselected

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=max(date[Date])))

Cumm Based on Date = CALCULATE([Net], Window(1,ABS,0,REL, ALLSELECTED('date'[date]),ORDERBY('Date'[date],ASC)))

[HM615]

Thank you so much! That's done it. I swapped ALL for ALLSELECTED in my measure and it's working now. Thank you!!