PowerBi Dax table True False based on multiple rows values

[RAVICHANDRA]

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

[Ahmedx · Accepted solution]

create a calculated column like this:

[andhiii079845]

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