Forum Discussion

Ronning's avatar
Ronning
Frequent Visitor
4 years ago
Solved

Two min values

 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

Need Help
  • daniel79's avatar
    daniel79
    4 years ago

    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]))

1 Reply

  • daniel79's avatar
    daniel79
    Resolver II
    4 years ago

    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]))