Do a SUMIFS() excel formula but in DAX

[JEM_Systems]

Hello Everyone, how can I do this formula cleary simple in Excel but in DAX? I'm struggling to get it.

=T3/SUMIFS(T:T,AM:AM,AM3)

[mh2587 · Accepted solution]

SumIF = //try this
DIVIDE(
    Table1[T3],
    CALCULATE(
        SUM(Table1[T]),
        FILTER(
            Table1,
            Table1[AM] = EARLIER(Table1[AM])
        )
    )
)