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])

     

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    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
    Icon for Community Support rankCommunity 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.