Forum Discussion
Solved
PowerBi Dax table True False based on multiple rows values
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
create a calculated column like this:
2 Replies
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 _filtercreate a calculated column like this:
