Count on condition from multiple sorting condition

Hi,

I'm trying to create a new custom column for my table which it's gonna count the sort order from other collumns on some condition:

1. it's should be on the same date

2. it should be sorted on it's value on descending order

this is the image for what I want to do:

date_column      |       value_column     |          my_custom_column     |

2019/06/14        |                 8               |                         3                    |

2019/06/14        |                 9               |                         2                    |

2019/06/14        |                10              |                         1                    |

2019/06/15        |                 7               |                         2                    |

2019/06/15        |                 8               |                         1                    |

I've tried this DAX code :

CALCULATE(COUNT('my_table'[value_column]),FILTER('my_table',AND([date_column]=MAX([date_column]),[value_column]<MAX([value_column]))))

but it's not returning the result that I want.

I wondering if there's someone who has a better idea for this.

regards,