Min Value Based on Measures Column

[Anonymous]

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

[v-cazheng-msft]

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.

[AnkitKukreja]

Hi @Anonymous 

Please clearly state your requirement.

Try and use min function on your current measure.

Thanks,
Ankit Kukreja
www.linkedin.com/in/ankit-kukreja1904

[amitchandak · Accepted solution]

@Anonymous , not ver clear ,

You need

min(table[Quantity])

or

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