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('ManufacturingOperatio...
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]))
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]))