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...
igorpereiradaco's avatar
igorpereiradaco
Frequent Visitor
2 years ago

Friend, good afternoon.

 

What would it look like if I wanted to assign more status to the scenarios and items, as below:

 

if all tests are "Prevented user test" then scenario of the item "Prevented user test"

if all tests are "Not tested" then item scenario 'Not tested"

if all tests are "Prevented" then item scenario "Not tested"

if all tests are "In user testing" then scenario of the item "In user testing"

if all tests are "Approved" then scenario of the item "Approved"

 

 

if all scenarios are "Prevented user test" then test the item "Prevented user test"

if all scenarios are "Not tested" then test the item 'Not tested"

if all scenarios are "Prevented" then test the item "Not tested"

if all scenarios are "Under test" then test the item "Under test"

if all scenarios are "Approved" then test the item "Approved"

  • talespin's avatar
    talespin
    Icon for Solution Sage rankSolution Sage
    2 years ago

     igorpereiradaco 

     

    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: