Forum Discussion

RAVICHANDRA's avatar
RAVICHANDRA
Frequent Visitor
3 years ago
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 onl...
Need Help
  • Ahmedx's avatar
    Ahmedx
    3 years ago

    create a calculated column like this:

andhiii079845's avatar
andhiii079845
Icon for Solution Sage rankSolution Sage
3 years ago

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