Calculate, Sum, Filters - Dax Query

Hi JKHATRAK ,

Please update the formula of the measure [Last Engagement Made Greater than 15 days] as below and check if it works or not... 

Last Engagement Made Greater than 15 days =
CALCULATE (
    SUM ( 'Raw Data'[USD] ),
    FILTER (
        'Raw Data',
        'Raw Data'[Days since last engagement] = "Greater than 15days"
            && 'Raw Data'[Excuse Code Description]
            IN {
            "Business Interruption",
            "Contact Made",
            "Credit Balance Known to customer",
            "0.Default",
            "9.Govmt/Institution Slow Pay/Funding",
            "7.Payment Awaiting Approval",
            "11.Pending Support from Business",
            "4.Customer Researching",
            "5.Credit Balance,In Research",
            "6.Unresponsive Customer",
            "1.Initial Contact pre due date"
        }
            && 'Raw Data'[Pocket] IN { "1-30", "31-60", "61-90", "91-120", "Over 120" }
    )
)

And you can use DAX Formatter to format your formula and check there is no syntax error...

If the above one can't help you get the desired result, please provide some sample data in your table 'Raw data' (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards