Calculation for the time/date

Anonymous , By assuming from current details you have provided you must have an date column 

Create a Calculated Column:
Go to the "Modeling" tab in Power BI Desktop.
Click on "New Column".

Ensure your dataset includes at least the following columns:
State, Total Number of Leading Cases, Years in Stand

New measure:

CasesMoreThan6Years = 
SUMX(
YourTableName,
IF(
YourTableName[YearsInStand] > 6,
YourTableName[TotalNumberOfLeadingCases],
0
)
)

 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

Hi Anonymous ,

You can create a measure as below to get the count of cases which more than 5 years:

Case of which for more than 5 years = 
CALCULATE (
    DISTINCTCOUNT ( '4CecLeadingCase4'[CecCaseId] ),
    FILTER (
        'CecCaseDetail',
        DATEDIFF ( 'CecCaseDetail'[DefinitiveJudgmentDate], TODAY (), YEAR ) > 5
    ),
    'CecCaseDetail'[Case] = "Stand"
)

Best Regards