Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
100 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |