Forum Discussion

yonghao's avatar
yonghao
Regular Visitor
3 years ago

Help! How to sum up minimums?

 

Hey guys, I'm trying to sum up the minimums I got from this formula: min(balanced order qty, physically available).

I tried sumx(table, min(balanced order qty, physically available)) but didn't work. Highlight above is what I expect to get.

 

Thank you so much!!!

DAX
min
sumx
Sumx()

1 Reply

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    3 years ago

    Hi,

    Please try to write a measure something like below.

     

    Expected measure: =
SUMX (
    'Table',
    MIN (
        CALCULATE ( SUM ( 'Table'[Balanced Order qty] ) ),
        CALCULATE ( SUM ( 'Table'[Physically available] ) )
    )
)