Hi Sindhu,
Use below DAX code to create a column using -
count if = IF(table[dept]="Design",CALCULATE(COUNTA(table[projects]),DATESBETWEEN(table[Date field],[start date], [end date])))
Now add the teams in sheet along with created column to show number of projects per project in design department.
Hope it helps you.