DAX to SUM over column with already cumulative in time values, by different category context

user_3918267 0
Viewed 39

this is my data:

enter image description here

I need a sum of latest cumulative values (column/not measure) depending on project filter context. Eg. if I use slicer for x,y I need 13 as in rightmost column:

enter image description here

Thanks

dax powerbi
1 Answers
VAR projectLastDates=
        ADDCOLUMNS(
            Values(tbl[proj])
            ,"lastDate",CALCULATE(LASTDATE(tbl[date]))
        )
VAR lastValues=
        ADDCOLUMNS(
            projectLastDates
            ,"lastValue",   VAR lastProjDate=[lastDate] 
                            RETURN 
                                CALCULATE(
                                    SUM(tbl[cum])
                                    ,tbl[date]=lastProjDate
                                )
        )
RETURN SUMX(lastValues,[lastValue])
user_190423790
Related