Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Min Value Based on Measures Column

Hi Team,   I have done new measure for sum_stock however based on sum_stock measure i need min value for each UID.       Thanks, KV's
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , not ver clear ,

     

    You need

    min(table[Quantity])

    or

    minx(values(Table[UID]),[sum_stock])

     

v-cazheng-msft's avatar
v-cazheng-msft
Community Support
5 years ago

Hi, Anonymous 

You can try the following Measure and then create a Table visual.

Min_each_UID = MINX('DIM',[Sum_Stock])

 

The result looks like this:

 

Best Regards,

Caiyun Zheng

 

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.