PowerPivot sum smallest numbers

[kent2ben]

Hi,

Can anyone help me with a dax syntax that will calculate the sum of the smallest numbers?

weeks	category	sales
week 1	F	3			category	sales
week 1	S	10			F	23
week 1	K	6			S	37
week 1	K	9			K	8
week 1	S	7
week 1	F	20
week 2	F	20
week 2	S	30
week 2	K	10
week 2	K	2
week 2	S	90
week 2	F	40

<colgroup><col width="56" span="7" style="width:42pt"> </colgroup><tbody>
</tbody>

 

[Tianbas]

please have a look at another post from today as this is more or less the same problem.

http://www.mrexcel.com/forum/power-bi/808615-how-summarize-earliest-worked-date-per-person.html