topic Re: help to solve logical problem in DAX Commands and Tips

help to solve logical problem

igorpereiradaco — Sun, 24 Mar 2024 00:29:25 GMT

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 proposal is that, if the tests linked to a given scenario are approved, then the scenario must be marked as "ok".

Additionally, if all scenarios linked to an item are marked as "ok", then the item is also marked as "ok".

Re: help to solve logical problem

AnalyticPulse — Sun, 24 Mar 2024 04:24:47 GMT

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

Re: help to solve logical problem

talespin — Sun, 24 Mar 2024 05:20:55 GMT

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")

Re: help to solve logical problem

igorpereiradaco — Sun, 24 Mar 2024 13:06:39 GMT

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

Re: help to solve logical problem

igorpereiradaco — Sun, 24 Mar 2024 13:07:42 GMT

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

Re: help to solve logical problem

talespin — Sun, 24 Mar 2024 13:31:22 GMT

hi igorpereiradaco

Sharing Pbix file.

https://drive.google.com/file/d/1WSWYxgFnaK7uPvzGH2X02N2raeax5VYU/view?usp=sharing

Re: help to solve logical problem

igorpereiradaco — Sun, 24 Mar 2024 21:42:05 GMT

Thank you for your support

Re: help to solve logical problem

igorpereiradaco — Mon, 25 Mar 2024 17:15:02 GMT

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"

Re: help to solve logical problem

talespin — Thu, 28 Mar 2024 02:40:02 GMT

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:

https://drive.google.com/file/d/1JuKP4thct2PE8qgdvIXtkPuVBOJ2-17O/view?usp=sharing

Re: help to solve logical problem

igorpereiradaco — Wed, 27 Mar 2024 11:23:26 GMT

Can you send me the pbix? Thank you very much, friend.

Re: help to solve logical problem

talespin — Thu, 28 Mar 2024 02:40:27 GMT

hi igorpereiradaco

Sharing file link

https://drive.google.com/file/d/1JuKP4thct2PE8qgdvIXtkPuVBOJ2-17O/view?usp=sharing