Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Finding Min Value within Column

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...
Need Help
  • Bifinity_75's avatar
    Bifinity_75
    3 years ago

    Hi Anonymous , try this measure:

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

     

    The result:

     

    Best regards

     

Bifinity_75's avatar
Bifinity_75
Solution Sage
3 years ago

Hi Anonymous , try this measure:

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

 

The result:

 

Best regards