How to FInd the MAX date for a particluar license number

[Rkrama746]

I am trying to find MAX date for a particular License number but i am not able to acheive this.

Please find these for refrence

_MsrMaxExpirationDate =
MAXX(
SUMMARIZE(
DimStaffLicenses,
DimStaffLicenses[LicenseNumber],
"MaxExpirationDate", MAX(DimStaffLicenses[ExpirationDate])
),
[MaxExpirationDate]
)

But not getting MAX date with this condtion

[Fowmy · Accepted solution]

@Rkrama746 

Create this measure and use it:

_MsrMaxExpirationDate =
CALCULATE (
    MAX ( DimStaffLicenses[ExpirationDate] ),
    ALLEXCEPT ( DimStaffLicenses, DimStaffLicenses[LicenseNumber] )
)

[Rkrama]

Thanks A lot