Forum Discussion
rp2022
Helper II
Helper IICummulative / Running total based on 2 criteria
Below is the data
| Number | R | P | Label | Group | $ |
| 1 | K | u1 | PD | PD | 100 |
| j2 | N | u2 | PD | PD | 200 |
| 3 | N | u3 | PD | PD | 500 |
| 1 | K | u1 | Aug-24 | Date | 900 |
| 6 | N | u2 | PD < CY | PD < CY | 600 |
| t2 | K | u4 | Dec-24 | Date | 400 |
| 3e | N | u3 | PD | PD | 500 |
| gt6 | N | u2 | Aug-24 | Date | 700 |
| asdf3 | K | u1 | S | Date | 800 |
| asdf7845 | N | u4 | Dec-24 | Date | 9000 |
| adfa564569 | K | u3 | PD | PD | 100 |
| 1 | N | u1 | PD < CY | PD < CY | 600 |
| j3 | N | u2 | Jun-24 | Date | 6000 |
| 4 | K | u3 | S | Date | 5000 |
| f52r | N | u1 | PD | PD | 6500 |
| 7 | K | u2 | Jul-24 | Date | 266 |
| t3 | N | u4 | Sep-24 | Date | 2555 |
| 3e | N | u3 | Dec-24 | Date | 56632 |
| gt7 | K | u2 | PD | PD | 28996 |
| asdf15687 | N | u1 | PD < CY | PD < CY | 6352 |
| 1 | K | u4 | Sep-24 | Date | 5569 |
| adfa564570 | N | u3 | Dec-24 | Date | 5626 |
| 3 | N | u1 | PD | PD | 5989 |
| j4 | K | u2 | Aug-24 | Date | 998 |
| 1 | N | u3 | PD < CY | PD < CY | 889 |
| 1 | K | u1 | Dec-24 | Date | 7895 |
| 8 | N | u2 | PD | PD | 8956 |
| 1 | N | u4 | S | Date | 565 |
| 3e | K | u3 | Sep-24 | Date | 56 |
And here the output i want:
I have a measure that does somewhat a good job, but when i filter by a perticular label, it shows values only for that label and not th ecumulative value. SO, I thought that i need a calculated column, which is not working.
Measure $ =
VAR __group = MAX('Data'[Group])
VAR __cur_date = MAX('Data'[Date])
VAR __result = CALCULATE(SUM('Data'[Total $]),FILTER(ALLSELECTED('Data'),'Data'[Group]=__group && 'Data'[Date]<=__cur_date))
RETURN
__result
