Counting instances

Hi,

Please check the below picture and the attached pbix file.

Total count CC = 
COUNTROWS (
    FILTER (
        Data,
        Data[UNID] = EARLIER ( Data[UNID] )
            && Data[From Date] <= EARLIER ( Data[From Date] )
    )
)

In year count CC = 
COUNTROWS (
    FILTER (
        Data,
        Data[UNID] = EARLIER ( Data[UNID] )
            && YEAR ( Data[From Date] ) = YEAR ( EARLIER ( Data[From Date] ) )
            && Data[From Date] <= EARLIER ( Data[From Date] )
    )
)

Hi,

Thank you for your reply.

I am not sure if I correctly understood your second questions, but please check the below picture and the attached pbix file whether it suits your requirement.

Expected CC =
VAR _toponebyyeartable =
    TOPN (
        1,
        FILTER (
            Data,
            Data[UNID] = EARLIER ( Data[UNID] )
                && YEAR ( Data[From Date] ) = YEAR ( EARLIER ( Data[From Date] ) )
        ),
        Data[In year count CC], DESC
    )
RETURN
    IF (
        MAXX ( _toponebyyeartable, Data[In year count CC] ) = Data[In year count CC],
        Data[In year count CC]
    )