Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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?
Solved! Go to 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 , 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)))
Thank you so much! That's done it. I swapped ALL for ALLSELECTED in my measure and it's working now. Thank you!!
User | Count |
---|---|
11 | |
11 | |
8 | |
6 | |
5 |
User | Count |
---|---|
25 | |
19 | |
16 | |
10 | |
7 |