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
Super UserhI rkaul ,
Try changing your formula from ALLSELECTED to just ALL.
Cumulative Chargebacks Number =
CALCULATE (
[Number of Chargebacks],
FILTER (
ALL ( CB_report_Chargeback_data[Lag (weeks) (bins)] ),
CB_report_Chargeback_data[Lag (weeks) (bins)]
<= MAX ( CB_report_Chargeback_data[Lag (weeks) (bins)] )
)
)Otherwise, please post a sample anonimized data.
Here is the sample data
https://drive.google.com/file/d/1wMk6MORmKAb2HAPZPeM8diuHVyZJhEE9/view?usp=sharing
When I apply the transaction date filter, it creates an issue.
- danextian
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
yes, i'm using an external date (calendar) table inplace of transaction date, you're right. From your PBI, it looks like transaction date works fine, but calendar date slicer (connected to the transaction date) doesn't seem to work. Is there a resolution to that? sorry i'm a bit new to PBI.
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 😄