Replicate Excel MAXIFS condition in PowerBI

[Anonymous]

Hello !

How to replicate below MAXIFS excel formula in powerBi ?
=MAXIFS(L:L,A:A,A2)

[themistoklis · Accepted solution]

@Anonymous 

Try the following:

MAX_SUBID = CALCULATE(MAX('Table'[Sub_ID ]), ALLEXCEPT('Table', 'Table'[ID]))

-- Excel
=MAXIFS(L:L,A:A,A2)
L:L = Sub_ID

A:A = ID