dax query to count distinct rows in column with latest date

[afeer]

I have data set like this 

Sr. No.	CNIC	Creation_Date
1	1234	20-Jan-23
2	1235	23-Jan-23
3	1236	16-Mar-23
4	1234	26-Mar-23
5	1234	27-Mar-23
6	1235	16-Apr-23
7	1234	20-May-23
8	1236	2-Jun-23
Resulted data set may look like
	CNIC	Creation_Date
1	1234	20-May-23
2	1235	16-Apr-23
3	1236	2-Jun-23
and results would be
CNIC	3

I can distict count separetly on CNIC and Creation Date but unable to get combined. Please guide...

[Dangar332 · Accepted solution]

Hi, @afeer 

try below code 

maxdate = 
   MAX(Table1[Creation_Date])



count of cnic = 
    COUNTX(
      FILTER(
        ALL(Table1[CNIC]),
        MAX(Table1[Creation_Date]) 
             ),
      Table1[CNIC]
           )