DAX to show count of max ID in Matrix

[Anonymous]

I'm not sure if my subject makes sense. So here is my question:

I have a table (just an example)

LeadID	Status	CreatedDate
A	Lead	6/1/2020
A	Contact	6/14/2020
A	Success	6/16/2020
B	Lead	6/2/2020
B	Success	6/6/2020

I am currently using this measure:

Count of ID = CALCULATE(COUNT(Table[LeadID]))

Then I made a matrix that looks like this:

Row Group: Status

Column Group: Day (from my date table)

Values: Count of ID

	Day	Day	Day	Day	Day
Status	1	2	6	14	16
Lead	1	1
Contact				1
Success			1		1

Date Slicer: 2020-06-01 to 2020-06-16

However, this is not my intended outcome. My intended outcome is to only show the count of the latest status based on the date slicer. below are some examples of my what I want:

Example 1 -

Date Slicer: 2020-06-01 to 2020-06-16

	Day	Day
Status	6	16
Success	1	1

Example 2 -

Date Slicer: 2020-06-01 to 2020-06-14

	Day	Day
Status	6	14
Contact		1
Success	1

Example 3 -

Date Slicer: 2020-06-01 to 2020-06-01

	Day
Status	1
Lead	1

[amitchandak · Accepted solution]

@Anonymous , I think dynamic segmentation ,binning

https://www.daxpatterns.com/dynamic-segmentation/

https://radacad.com/grouping-and-binning-step-towards-better-data-visualization

https://www.daxpatterns.com/static-segmentation/
https://www.poweredsolutions.co/2020/01/11/dax-vs-power-query-static-segmentation-in-power-bi-dax-power-query/