Two min values

[Ronning]

 Hi i want to show the min of OperationNumber for every MONumber. But as you can see i get two min  values  for one MONumber. 

I have tried this...

Min OPnr = CALCULATE( MIN('ManufacturingOperation'[OperationNumber]), filter('ManufacturingOperation','ManufacturingOperation'[OperationNumber] = min('ManufacturingOperation'[OperationNumber] )))

But it still showe 10 and 20 for MinOPnr for one MONumber

Thanks Ronning

[daniel79 · Accepted solution]

If you want to get the min operation number regardless of other selected columns in the table you can try something like this

CALCULATE(MIN(ManufacturingOperation[OperationNumber]), ALLEXCEPT(ManufacturingOperation, ManufacturingOperation[MONumber]))