Forum Discussion

sadiahsapiee's avatar
sadiahsapiee
Icon for Helper I rankHelper I
6 years ago
Solved

Cumulative value from measure column not correct

Why my DAX to calculate cumulative not continue from previous row? Week         Confirm Del Plan           CDP 2019/49       139  <- TableA            139 2019/50        281 <- TableA             ...
Need Help
  • sadiahsapiee's avatar
    sadiahsapiee
    6 years ago

    Finally  I got the solution

     

    Cumulative CDP = SUMX(

      FILTER (ALLSELECTED('Date');

    'Date'[DateKey] <=MAX('Date'[Datekey]));

    [Confirm Del Plan]

    )

     
    Thanks to all to Paul and Kentyler for the suggestion and idea.
sadiahsapiee's avatar
sadiahsapiee
Icon for Helper I rankHelper I
6 years ago
Spoiler
 

Hi,

 

Actually, I have Date table which DateKey link to Date column in both Table A and TableB.

Relationship is already created Date[DateKey]<- TableA[Date] & Date[Datekey]<->TableB[Date]. So the Year/Week is from Date table.

sadiahsapiee's avatar
sadiahsapiee
Icon for Helper I rankHelper I
6 years ago

finally I found the solution by changing the formula like this

-> **bleep** CDP =SUMX(
   FILTER(ALLSELECTED('Date');
   'Date'[DateKey] <=MAX('Date'[DateKey]));
   [Confirm Del Plan]
)
 
The table shows the cumulative value correctly. 

Thanks to all that gave idea and suggestion.