How to get min value from calculated based on one column

[pokarman]

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

[Jimmy801]

Hello @pokarman 

have you been able to solve the problem with the replies given?

If so, 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

All the best

Jimmy

[Jimmy801]

Hello @pokarman 

you need to have this in a visualization or in power query as new calculated column?

Jimmy

[pokarman]

visualisation

[Jimmy801]

Hello @pokarman 

create a new measure like MinMinPrice = Min(YourTableName[MinPrice])

Then create table in your visualisation, drag the plant and the new measure into your visualization.

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

[pokarman]

Its not working

[Jimmy801]

Hello

what is the error message? could you post the error/measure/table?

Jimmy

[pokarman]

[dax]

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]

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]

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

[Jimmy801]

Hello @pokarman 

the formula MIN requires only one parameter... I dont know whats QTY is, but if its your table then the measure its like MIN(QTY[MinPrice]).

Jimmy