Forum Discussion

igorpereiradaco's avatar
igorpereiradaco
Frequent Visitor
2 years ago
Solved

help to solve logical problem

I would like to create a condition in DAX that allows me to display the status of the item based on the scenario associated with it and the status of the tests associated with that scenario. The pro...
talespin's avatar
talespin
Icon for Solution Sage rankSolution Sage
2 years ago

hi igorpereiradaco 

 

Please try these measures

 

ScenarioStatus =
VAR _MinVal = CALCULATE( MINX(LogicalProblem, IF(LogicalProblem[Column1] = "ok", 1 , 0) ), REMOVEFILTERS(), VALUES(LogicalProblem[Scenario]) )
RETURN IF(_MinVal = 1, "ok", "Not ok")
 
ItemStatus =
VAR _MinVal = CALCULATE( MINX(LogicalProblem, IF(LogicalProblem[Column1] = "ok", 1 , 0) ), REMOVEFILTERS(), VALUES(LogicalProblem[ItemID]) )
RETURN IF(_MinVal = 1, "ok", "Not ok")
 

 

  • igorpereiradaco's avatar
    igorpereiradaco
    Frequent Visitor
    2 years ago

    Good morning. Thanks for the feedback. The solution is this. Can you send me this pbix file?