Forum Discussion
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...
This should do it. I noticed one thing, you have
if all tests are "In user testing" then scenario of the item "In user testing"
if all scenarios are "Under test" then test the item "Under test"
ScenarioStatus =
VAR _MinVal = CALCULATE(
MIN(LogicalProblem[Column1]),
REMOVEFILTERS(),
VALUES(LogicalProblem[Scenario])
)
VAR _MaxVal = CALCULATE(
MAX(LogicalProblem[Column1]),
REMOVEFILTERS(),
VALUES(LogicalProblem[Scenario])
)
RETURN IF(
_MinVal = _MaxVal,
IF(_MaxVal = "Prevented", "Not tested", _MaxVal),
"NA"
)
-----------------------------------------------------------------------------
ItemStatus =
VAR _MinVal = CALCULATE(
MIN(LogicalProblem[Column1]),
REMOVEFILTERS(),
VALUES(LogicalProblem[ItemID])
)
VAR _MaxVal = CALCULATE(
MAX(LogicalProblem[Column1]),
REMOVEFILTERS(),
VALUES(LogicalProblem[ItemID])
)
RETURN IF(
_MinVal = _MaxVal,
IF(_MaxVal = "Prevented", "Not tested", _MaxVal),
"NA"
)
File Link:
Can you send me the pbix? Thank you very much, friend.