Forum Discussion
Using MIN and WHERE
Hello,
After creating the measure, try creating a table and put forwarder code and this measure. You should see the minimum for each forwarder code. If it is not coming then you must have more than two tables in your dataset and then the issue is there in relationship between them
Try using Quick Measures and or else you can create measures of your own.
Example:
MinimumDuration = MIN(DURATION)
I have tried this, but the problem is that it shows the min value of the whole column instead of the min value per forwarder code.
HI AVZ
Try this MEASURE
MEASURE= CALCULATE ( MIN ( TableName[Duration] ), ALLEXCEPT ( TableName, TableName[FORWARDER_CODE] ) )Hi Zubair,
Thank you for your comment!
I get the same result i got earlier while using: MIN(test123[Duration]
It shows me the lowest value in the duration column, I would like it to show me the lowest value per FORWARDER_CODE.
I have forwarder codes named DPD, UPS, DHL, PNL and ROY, I would like to see the min value per each one of those codes.
Hello,
After creating the measure, try creating a table and put forwarder code and this measure. You should see the minimum for each forwarder code. If it is not coming then you must have more than two tables in your dataset and then the issue is there in relationship between them
