Dax Help on counting the number of leads based on Max date column

[PowerBigginer]

Dear Team,
I need help on DAX function below is my sample data
LEAD_CREATED          LEAD_#          LEAD_STATUS_DATE     SUBMITTED_DATE    SALES_ASSIGN_DATE     DECISION_DATE
3/24/2024 12:41   1-6911852285      4/18/2024 18:13          3/24/2024 23:21       3/24/2024 23:14
3/24/2024 12:40   1-6911851975      3/24/2024 23:54         3/24/2024 23:04       3/24/2024 23:00

This is my sample data 
here I want to create count(Lead_#) 
If you see second row all dates are on 24th Mar here I want to take max date which means Lead_Status_Date is Max I want this count in Lead_Status_Date count should not repeat in other dates and this should change based on date selection 
I have given relationship with lead_created but it should use userelationship with Lead_status_date same goes to all other dates.
Hope this is clear 

[amitchandak]

@PowerBigginer , Not very clear

You can create a new column

Date = maxx({[LEAD_STATUS_DATE], [SUBMITTED_DATE],[SALES_ASSIGN_DATE], [DECISION_DATE]}, [Value] )

and join that with date table

[PowerBigginer]

Any solution for this issue ?