Cumulative total should display till the value exist

[DBA_BI]

Hello All,

I have two following measures, 

1. Planned = Cumulative total of all planned (Admin, training) hours accorss different tasks ( 3 to 10)

2. Actual = Cumulative total of actual hours Admin hours completed accross different tasks ( Note : Only till Task 6 there are completed Admin hours and there are no admin hours clocked against the remaining tasks 7,8,9,10 )

But the visual would continue to show data till the last task, which is not necessary . Instead Actual completed hours should show values till task 6 only.

How do we achive this ?

[DBA_BI]

Thank you so much @amitchandak. You are always been a great support to the whole Power BI community.

[amitchandak · Accepted solution]

@DBA_BI , assume you have a measure Actual, try a measure like

if(isblank([Actual]), blank(), calculate([Actual), filter(allselected(Task), Task[ID] <= Max(Task[Id]) ) )