Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |