SUMX with more than one filters

[Waseem]

Hello community

I am trying to filter a table for two column values. I need a SUMIFS sort of result whereby I could sumup "Amount" by filtering a date column  (i already did this with below formula) and another filter to be applid on 'Table 1[status]' column where status is "Good". I do not know how to apply two filters in one SUMX formula. Apprciate your usual kind help.

The current formula that i am using for date filter based on current row date is as under:

SUMX(FILTER('Table 1,'Table 1'[Date]=EARLIER('Table 1'[Date])),[Amount])

Cheers

[Zubair_Muhammad · Accepted solution]

@Waseem

Try with

Formula =
SUMX (
    FILTER (
        'Table 1',
        'Table 1'[Date] = EARLIER ( 'Table 1'[Date] )
            && 'Table 1'[status] = "good"
    ),
    [Amount]
)

[Waseem]

Great.. thanks a lot Mohammed