Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |