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...
AnalyticPulse's avatar
AnalyticPulse
Icon for Solution Sage rankSolution Sage
2 years ago

do the following:

Create a Calculated Column for Scenario Status

Scenario Status = VAR ScenarioID = 'YourTableName'[Scenario] RETURN IF ( COUNTROWS ( FILTER ( 'YourTableName', [Cenario] = ScenarioID && [Teste Status] <> "Approved" ) ) = 0, "Ok", "Not Ok" )

 

 Create a Calculated Column for Item Status

Item Status = VAR ItemID = 'YourTableName'[Item ID] RETURN IF ( COUNTROWS ( FILTER ( 'YourTableName', [Item ID] = ItemID && [Scenario Status] <> "Ok" ) ) = 0, "Ok", "Not Ok" )

 

If this helped, Follow this blog for more insightful information about data analytics
https://analyticpulse.blogspot.com/
Please Subscribe AnalyticPulse on YouTube for future updates:
https://www.youtube.com/@AnalyticPulse
Please subscribe CogniJourney On Youtube For Daily fun facts:
https://www.youtube.com/@CogniJourney

igorpereiradaco's avatar
igorpereiradaco
Frequent Visitor
2 years ago

Good morning. Thanks for the feedback. I couldn't do it that way.