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 di...
DAX
min
sumx
Sumx()
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper 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] ) )
    )
)