Divide column value by distinct count of another column

[Jay0610]

Hi, 

On the example below for Type 'Parts' there are 24 distinct dates for February (the dates are not all shown in this screen shot)

I would like to divide 'parts month target' by 24 to give me a 'daily target', so 50000/24.

There are more months in the table.

Is this possible using DAX?

Thanks 

[amitchandak]

@Jay0610 ,

divide(Sum(Target[Target]), calculate(distinctcount(Table[Part]), allexcept(Table[Month Year]) ))

[Jay0610]

Thank you. 'Parts' is not a column but a possible value of the 'Type' column. I guess I can amend the calculation to include a filter?