The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to Solution.
@Anonymous , not ver clear ,
You need
min(table[Quantity])
or
minx(values(Table[UID]),[sum_stock])
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.
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
User | Count |
---|---|
78 | |
74 | |
42 | |
32 | |
28 |
User | Count |
---|---|
104 | |
93 | |
52 | |
50 | |
46 |