Cumulative Emission with Filter condition
Hi Community, Data PowerBI File Could you please help me finding cummulative emission with Filter condition I want to create a measure that can calculate emission up till Forecast value is "N". I am trying with following measure but I am still getting values where forecast is "Y". so, my goal is create measure that calculate cummulative total up till Forecast value is "N" and rest is blank. I guess it is happenig becasue of ALL. Actual Cumulative Emissions = VAR _table = FILTER ( ALLSELECTED(data), data[Date] <= MAX( data[Date])&&data[Forecast]="N") VAR _cumulative_before_forecast = CALCULATE( SUM(data[Emission]) , _table) Return _cumulative_before_forecast My expected results should look like this Thankyou in Anticipation
