Dax Calculation on power bi

file excel and pbix 

hai i wanna calculate total vehicle and total average base on dept like this 

on facility management (FM)

i got total average = 

and total vehicle = 50

on finish good (FG)

i got total average = 

and total vehicle = 28

but on my power bi, i canot make data like this 

this is my total vehicle divide by dept

SumDistinctIfDifferent = 
VAR DistinctInternalIDs = 
    VALUES( 'Table 2024-08-06 until 2024-08-27 (2)'[Total Vehicle 2] )
RETURN
    SUMX(
        DistinctInternalIDs,
        CALCULATE(
            DISTINCTCOUNT( 'Table 2024-08-06 until 2024-08-27 (2)'[internal_id]),
            ALLEXCEPT( 'Table 2024-08-06 until 2024-08-27 (2)', 'Table 2024-08-06 until 2024-08-27 (2)'[dept_id] )
        )
    )

how to calculate total vehicle and total average like my excel ??

total vehicle what i made

Total Vehicle = DISTINCTCOUNT('Table 2024-08-06 until 2024-08-27 (2)'[internal_id])

DB sql source code :

select distinct internal_id, type, status, unit, operational_date, time_start, time_finish,  dept_id from vms_vhl_operational where operational_date between '2024-08-06' and '2024-08-27' and unit = 'MAIN'