Create a measure to get the max of a cumulative measure

[prab]

I have column "PO Value" of each product each week and have created a measure "CummPO" that calculates cummulative of "PO Value"

Now need to create a  new measure POComplete that is MAX("CummPO") for the complete horizon minus "CummPO" upto that week..

However when adding the "POComplete" to any visual for example it error's out as "Query has exceeded available resources."Can some one help to fix this issue?

below are the measure..

CummPO =
CALCULATE(
    SUM(mytable[POValue]),
    FILTER(
        ALL('DimDate'[WeekStartDate]), //ALLSELECTED
        ISONORAFTER('DimDate'[WeekStartDate], MAX('DimDate'[WeekStartDate]), DESC)
    )
)
 
POComplete =
var maxCumltvPO =  CALCULATE(MAXX(ALL(mytable) ,[CummPO]))
RETURN maxCumltvPO - [CummPO]

[parry2k]

@prab @Not sure I understood what you mean. If original question is solved , accept the solution and create another post with the next question and tag me into it. 

[parry2k · Accepted solution]

@prab I think this is what you need:

POComplete =
var maxCumltvPO = CALCULATE (
    SUM ( myTable[POValue] ),
    ALLSELECTED ( 'DimDate' )
)
RETURN maxCumltvPO - [CummPO]

[prab]

Thank you @parry2k or quick response.

Yes this works.. but have a question? 

Can we create a measure to generate the cummulative of "POComplete"?

Thanks again for your help!!

- Prab