Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I have a table as attached in snapshot below.
I want to create a measure which will incidate "Order More Stock" if Units available is less than Reorder level. If Units available is greater than reorder level then indicate "Sufficient stock"
Please see: Units available should be summed at all warehouses but Reorder level should be considered only once as shown in image above.
Thanks in advance
Solved! Go to Solution.
Hi @vrushabjain510 ,
Please try this measure:
Measure =
var max_reorder = CALCULATE(MAX('Table'[ReOrder Level]),ALLEXCEPT('Table','Table'[Product SKU]))
var sum_units = SUM('Table'[Units Available])
return SWITCH(TRUE(),
sum_units<max_reorder,"Order More Stock",
sum_units>=max_reorder,"Sufficient stock")
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@vrushabjain510 If you have Product SKU in a table visualization, then it out to be:
Measure =
VAR __UnitsAvailble = SUM('Table'[Units Available])
VAR __ReorderLevel = MAX('Table'[ReOrder Level])
RETURN
IF(__ReorderLevel <= __UnitsAvailable,"Order More Stock","Sufficient Stock")
Using your formula, Reorder Level is getting summed instead of taking Max
Hi @vrushabjain510 ,
Please try this measure:
Measure =
var max_reorder = CALCULATE(MAX('Table'[ReOrder Level]),ALLEXCEPT('Table','Table'[Product SKU]))
var sum_units = SUM('Table'[Units Available])
return SWITCH(TRUE(),
sum_units<max_reorder,"Order More Stock",
sum_units>=max_reorder,"Sufficient stock")
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
83 | |
71 | |
49 |
User | Count |
---|---|
143 | |
121 | |
111 | |
59 | |
57 |