Good DayI am trying to calculate the "Drawdown" row as per the below data table example.As you can see the TOTAL CUMATIVE Formula used gives the Cumulative by Year resulting in a value of $186 I am trying to Acheive the "DrawDown" calculation based on WIN(+) and NO WIN(-) by yearHence starting from $186 (Total Budget) - "NO WIN" + "WIN" So in the below example:=186-[5+0]-[25+0]-[15+0]-[5+16]-[15+10]-[30+0]-[25+15]-[15+10] Hence, i need support to develop the above measure Cumulative Drawdown by Year Thanks! Total_Cumulative_Overall =CALCULATE( [Budget], FILTER( ALLSELECTED('_Calendar'), ISONORAFTER(_Calendar[Date], MAX(_Calendar[Date]),DESC) ))

I don't pretend to understand the definition of drawdown (despite having read the article multiple times) but here is a solution proposal.

DAX Help to For Drawdown | Microsoft Fabric Community

Super User

Will each P value always only be either Win or No Win? Will that not change over time?

Please provide sanitized sample data that fully covers your issue. https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216 I can only help you with meaningful sample data.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

Helper V

lbendlin - The expected result is the "Drawdown" row below