Calculate Total Amount using Filter

Hi Anonymous ,
Thanks for Ashish_Mathur  rply.
Here are my measures

Total Expected Amount = 
CALCULATE(
    SUM('Table'[Expected Amount]),
    ALLEXCEPT(
        'Table',
        'Table'[Customer]
    )
)

Total Amount Paid = 
CALCULATE(
    SUM('Table'[Amount Paid]),
    FILTER(
        ALLEXCEPT(
            'Table',
            'Table'[Customer]
        ),
        'Table'[State] = "Paid" && 'Table'[Status] = "Paid by Customer" || 
        'Table'[State] = "Paid" && 'Table'[Status] = "Paid by Agency" ||
        'Table'[State] = "Paid" && 'Table'[Status] = "Paid by BU"
    )
)

Final output

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly