Need to add a filter to an existing DAX column

[chrismcdonald]

I am looking to add a Filter to the formula below

I want to add in a filter to only count the task_type "D1".     'Project type'[task_type] = "D1" 

Project Actual (Project Level) Column =

IF (

CALCULATE (

COUNTBLANK ( 'Table1'[actual_date] ),

ALLEXCEPT ('Table1', 'Table1'[project_id] )

) > 0,

BLANK (),

CALCULATE ( MAX ( 'Table1'[actual_date] ), ALLEXCEPT ('Table1', 'Table1'[project_id] ) )

)

Where / how do I add the filter into the formula above?

Thanks in advance

[amitchandak]

@chrismcdonald , Try one of the two

Project Actual (Project Level) Column =
IF (
CALCULATE (
COUNTBLANK ( 'Table1'[actual_date] ),
ALLEXCEPT ('Table1', 'Table1'[project_id] )
) > 0,
BLANK (),
CALCULATE ( MAX ( 'Table1'[actual_date] ), filter('Project type','Project type'[task_type] = "D1" ), ALLEXCEPT ('Table1', 'Table1'[project_id] ) )
)

or

Project Actual (Project Level) Column =
IF (
CALCULATE (
COUNTBLANK ( 'Table1'[actual_date] ),
ALLEXCEPT ('Table1', 'Table1'[project_id] )
) > 0,
BLANK (),
CALCULATE (CALCULATE ( MAX ( 'Table1'[actual_date] ), filter('Project type','Project type'[task_type] = "D1" )), ALLEXCEPT ('Table1', 'Table1'[project_id] ) )
)