Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
User | Count |
---|---|
102 | |
91 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |