Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello Experts!
Help me to get solution for the below issue, In Power Bi Dax table added calumn with IF condition and getting result like in "F"
(Excel table attached just for reference only)
Currently am able get this!-
If "Stock" is >= "Required" then set to InventoryOk to "True" else set "False";
What I need?
But my requirement is if anywhere in the table with same orderId condition found "False" then all the rows with that OrderId could set "False" (Yellow highlighted should be False for example)
Thankfully -Ravi
Solved! Go to Solution.
create a calculated column like this:
Hi, try this:
Measure =
VAR _table = SUMMARIZE(ALL('Table'),'Table'[OrderID],'Table'[ItemID],'Table'[Stock],'Table'[Required],"_check",if('Table'[Stock]>='Table'[Required],"ok","not ok"))
VAR _orderID = SELECTEDVALUE('Table'[OrderID])
VAR _filter = IF(COUNTX(FILTER(_table,'Table'[OrderID] = _orderID && [_check] = "not ok"),'Table'[ItemID])>=1,"no ok","ok"
RETURN _filter
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |