Totals sum not as expected.

[schmere]

Hi Community, 

depending on the the date my "demand" meassure either equals Actuals or a Forecast. The meassure works fine but the total is not summing up the demand but instead only shows first weeks result. If I select a future quarter or historical quarter the Sum is correct. The error only appears in the current quarter where the total of demand meassure can be a combination of forecast and Actuals. Any idea or suggestion how I can fix this so the current quarter sums up entire demand measure?

demand meassure:  

demand = If((TODAY()-7)>FIRSTNONBLANK(Sheet1[Period Start],Sheet1[Period Start]),[Actuals U],[Final demand])

Snapshot of total Demand.

Many Thanks

[schmere]

Thanks @amitchandak. That worked like a charm.

[amitchandak · Accepted solution]

@schmere , Try a measure

sumx(values(Sheet1[Date]), demand = If((TODAY()-7)>FIRSTNONBLANK(Sheet1[Period Start],Sheet1[Period Start]),[Actuals U],[Final demand]))