Forum Discussion

pokarman's avatar
pokarman
Frequent Visitor
6 years ago

How to get min value from calculated based on one column

In the below image there is Minprice calculated measure so i want to extract min value from that measure column based on plant code.   this column are coming from multiple tables
Show and Tell
dax's avatar
dax
Community Support
6 years ago

Hi pokarman , 

Yes, you could refer  to above suggestions, and show this is card or other visual. In addition, if this couldn't work, please inform me more detailed information(such as your expected output and your sample data)? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

pokarman's avatar
pokarman
Frequent Visitor
6 years ago

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

in above image there is vendor  performance table ,from that table i want to generate new column "lowest value" based on minprice column .lowest value colunm should pick lowest figure from minprice column.

  • Jimmy801's avatar
    Jimmy801
    Community Champion
    6 years ago

    Hello pokarman 

     

    and what is the problem using the measure MIN(QTY[MinPrice])?

    if not the complete row-context should be applied you would need to surround this measure with calculate. Something like this should then work out

    CALCULATE(MIN(QTY[MinPrice]);ALLEXEPT(QTY[Plant Code])) - not tested

     

    If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
    Kudoes are nice too

    Have fun

    Jimmy