Forum Discussion
Cumulative total issue for 0 count
hello rkaul ,
I created a measure using ALL instead of ALLSELECTED and the result seems fine
Cumulative Sum = CALCULATE ( SUM ( Sheet2[Chargeback Amount] ), FILTER ( ALL ( Sheet2[Lag (weeks)] ), Sheet2[Lag (weeks)] <= MAX ( Sheet2[Lag (weeks)] ) ) )Going back to your original post, what do you mean by sing an external date slicer? Are you using a separate dates table?
Anyway, here's the pbix based on your data: https://drive.google.com/file/d/1xc8F0qtTA_ydAMHetfyO0O58-6vyeVZG/view?usp=sharing
hello rkaul ,
I created a measure using ALL instead of ALLSELECTED and the result seems fine
Cumulative Sum =
CALCULATE (
SUM ( Sheet2[Chargeback Amount] ),
FILTER (
ALL ( Sheet2[Lag (weeks)] ),
Sheet2[Lag (weeks)] <= MAX ( Sheet2[Lag (weeks)] )
)
)
Going back to your original post, what do you mean by sing an external date slicer? Are you using a separate dates table?
Anyway, here's the pbix based on your data: https://drive.google.com/file/d/1xc8F0qtTA_ydAMHetfyO0O58-6vyeVZG/view?usp=sharing
I just deleted the original visual and redid it and it worked for some weird reason. I dont understand PBI many times, haha. Thanks a lot for your help 😄
Hi rkaul ,
Haha. I am actually not sure what you are trying to achieve. I am a bit confused so I modified the pbix a bit and created two additional measures.