Min Amount from Rangesum

[loganathan]

Hi All,

My current measure is 'RangeSum({<SUM({Flag={181}>}Amount1),SUM({Flag={181}>}Amount2))' and i need fine Min from this measure. Please let me know how i can achieve this. attached the sample data.

Expected min value is -300

[mdf]

This should work: MIN(AGGR({<FLAG={'181'}>}SUM(AMOUNT1+AMOUNT2) ,ID))

[marcus_sommer]

Try: RangeMin( { < Flag={181} >} sum(Amount1), SUM(Amount2))