Finding Min Value within Column

[Anonymous]

Need to find min value by test group. From below example, expect 

- Test Group (A) : Min = 12

- Test Group (B) : min = 10

I use below formula but didn't get correct result

Also try to use "Earlier" function but it keep showing error (cannot input parameter inside earlier).

Please help

[Bifinity_75 · Accepted solution]

Hi @Anonymous , try this measure:

Min Group = CALCULATE(min('Table'[Sum of Qty]),
ALLEXCEPT('Table','Table'[Test Group])
)

The result:

Best regards