Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
My running total script is not summing correctly values with 0.
This is how looks like a table with particular columns/measures. I think problem is because I have blank values for October 2020 in 6-th month.
Instead I tried to use measure: Defaulted - where I can see 0 but still I can't get the right values:
@Anonymous , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Try like
**bleep** PoD 30 =
VAR vMax = MAX(Arkusz1[PoD30])
RETURN
CALCULATE(
SUM(Arkusz1[Default30]),
FILTER(ALL(Arkusz1),
Arkusz1[PoD30] <= vMax && Arkusz1[Date] = max(Arkusz1[Date])
))
or
**bleep** PoD 30 =
VAR vMax = MAX(Arkusz1[PoD30])
RETURN
CALCULATE(
SUM(Arkusz1[Default30]),
FILTER(ALL(Arkusz1),
Arkusz1[PoD30] <= vMax && Arkusz1[year] = max(Arkusz1[year]) && Arkusz1[month] = max(Arkusz1[month])
))
I cannot add Arkusz1[date] to the Filter part as it's not a measure but just a column.
There you have sample data in table:
Year | Month | PoD30 | **bleep** PoD 30 | Default30 | Defaulted |
2020 | September | 0 | 0 | 0 | 0 |
2020 | September | 2 | 0 | 0 | |
2020 | September | 3 | 2 | 2 | 2 |
2020 | September | 4 | 0 | 0 | |
2020 | September | 5 | 3 | 1 | 1 |
2020 | September | 6 | 5 | 2 | 2 |
2020 | September | 7 | 0 | 0 | |
2020 | September | 8 | 0 | 0 | |
2020 | September | 9 | 0 | 0 | |
2020 | October | 0 | 0 | 0 | 0 |
2020 | October | 2 | 1 | 1 | 1 |
2020 | October | 3 | 2 | 1 | 1 |
2020 | October | 4 | 4 | 2 | 2 |
2020 | October | 5 | 6 | 2 | 2 |
2020 | October | 6 | 0 | 0 | |
2020 | October | 7 | 8 | 2 | 2 |
2020 | October | 8 | 9 | 1 | 1 |
2020 | October | 9 | 11 | 2 | 2 |
2020 | November | 0 | 0 | 0 | 0 |
2020 | November | 2 | 0 | 0 | |
2020 | November | 3 | 3 | 3 | 3 |
2020 | November | 4 | 5 | 2 | 2 |
2020 | November | 5 | 0 | 0 | |
2020 | November | 6 | 8 | 3 | 3 |
2020 | November | 7 | 11 | 3 | 3 |
2020 | November | 8 | 0 | 0 | |
2020 | November | 9 | 0 | 0 | |
2020 | December | 0 | 0 | 0 | 0 |
2020 | December | 2 | 2 | 2 | 2 |
2020 | December | 3 | 5 | 3 | 3 |
2020 | December | 4 | 6 | 1 | 1 |
2020 | December | 5 | 8 | 2 | 2 |
2020 | December | 6 | 9 | 1 | 1 |
2020 | December | 7 | 0 | 0 | |
2020 | December | 8 | 0 | 0 | |
2020 | December | 9 | 0 | 0 |