Getting Error on MAX funcation

[skorpionaa]

what i looking for is i have active tracking system where each product have there status so i need Total Count how many comaponies have Avtive status with latest date as most of companies have multi active status but we need only count latest date one

could you please help me wheree im wrong

im getting error

"

A funcation "Max" has been used in a true/false expression that is used as a table filter expression"

MaxCount =

CALCULATE(DISTINCTCOUNT(Companies[Name]),

MAX('Companies'[date]),FILTER(Companies,[Status] = "Active")

)