Creating a calculated column to sum values based on a condition

Hi  Tomburton2023 ,

According to your describe, here are my test process

To achieve your goal, you can follow these steps:

Here are my test data:

1.Create a calculate column by using DAX

 AnticipatedWIPFeePerMatter = 
CALCULATE(
    SUMX('Table','Table'[Amount]*'Table'[LikelyBilledValue]),
    FILTER('Table', 'Table'[Tiltle] = EARLIER('Table'[Tiltle]) && 'Table'[LikelyBilledValue] < 1)
)

2.Final output

^{In order for you to solve the problem faster, you can refer to the following documentation}

How to Get Your Question Answered Quickly - Microsoft Fabric Community

^{Best Regards,}

^{Albert He}