Forum Discussion

AVZ's avatar
AVZ
Frequent Visitor
8 years ago
Solved

Using MIN and WHERE

Hi,   I have a table with two columns named FORWARDER_CODE and DURATION, I would like to use the min max and avg functions on duration and show the results per unique forwarder_code. Any help would...
Need Help
  • prateekraina's avatar
    prateekraina
    8 years ago

    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

AVZ's avatar
AVZ
Frequent Visitor
8 years ago

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.

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

HI AVZ

 

Try this MEASURE

 

MEASURE=
CALCULATE (
    MIN ( TableName[Duration] ),
    ALLEXCEPT ( TableName, TableName[FORWARDER_CODE] )
)
  • AVZ's avatar
    AVZ
    Frequent Visitor
    8 years ago

    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.

    • Zubair_Muhammad's avatar
      Zubair_Muhammad
      Community Champion
      8 years ago

      AVZ

       

      Could you post a snaphot of the Table and RESULTS you are getting?

      • AVZ's avatar
        AVZ
        Frequent Visitor
        8 years ago

        It has been resolved thanks for helping me out!