Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
I have created a cumulative line using the below measure.
but when I filter specific value from a column as filter which is from same table the cumulative value is not changing.
Can anyone help me with this.
Solved! Go to Solution.
Hi @sv00001
This happens because you used the "All" function on a table level, this function removed all of the filters from the table.
Try to modify it to :
CALCULATE(SUM('Table'[value]),FILTER(allsellected('Table'[date]),'Table'[Date] <= MAX('Table[Date])))
more information about cumulative total with slicers is here
https://www.youtube.com/watch?v=snQhmAxnIYA
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi @sv00001
This happens because you used the "All" function on a table level, this function removed all of the filters from the table.
Try to modify it to :
CALCULATE(SUM('Table'[value]),FILTER(allsellected('Table'[date]),'Table'[Date] <= MAX('Table[Date])))
more information about cumulative total with slicers is here
https://www.youtube.com/watch?v=snQhmAxnIYA
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly