topic Creating a visual to have multiple condition to check if the criteria has been met. in DAX Commands and Tips

Creating a visual to have multiple condition to check if the criteria has been met.

CarryASaw — Mon, 22 Jan 2024 04:31:56 GMT

Hi, I am trying to create a visual using if statements in DAX. I never get to understand and how to properly explain what Im after but, Ill try my best.

I want to create a visual table to check students exam results, and return a value to tell if that section passed or failed.

If Student 1 = Math, History, Science is passed, and Student 2 = Math, History, Science is passed. Then Section 1 passed.
Else if any of student failed one subject, then Section 1 has failed.

The table is this:

By using the table above, Im trying to calculate if Section 1 passed or failed like this:

Any help would be really great. I would love to know if this is possible.

Im having trouble because this is texts, and not numbers. Im unable to calculate the result.

Thank you so much everyone!

Re: Creating a visual to have multiple condition to check if the criteria has been met.

Anonymous — Mon, 22 Jan 2024 09:46:21 GMT

Hi CarryASaw ,

Please follow these steps:

Since I wasn't very clear about the categorization of sections in your description, I created an extra column of sections as shown below:

1.Create the metric and write the following expression:

result = VAR _count = COUNTX(FILTER(ALL('Table'),'Table'[Section] = MAX('Table'[Section])&&'Table'[Exam Result] = "Failed"),[Exam Result]) RETURN IF(_count = BLANK(),"Passed","failed")

2.The result obtained is shown below:

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Creating a visual to have multiple condition to check if the criteria has been met.

CarryASaw — Wed, 24 Jan 2024 00:16:35 GMT

Hi Anonymous
It worked.
Just a follow up question though, how do I add more filter?

I tried adding filter like this:

result = VAR _count = COUNTX(FILTER(ALL('Table'),'Table'[Section] = MAX('Table'[Section]) && 'Table'[Exam Result] = "Failed"), 'Table'[Exam Result] = "Not Yet Submitted") ,[Exam Result]) RETURN IF(_count = BLANK(),"Passed","Failed")

I tried adding the "Not Yet Submitted" to be also considered as failed but no luck.

I tried to dabble with the code but DAX seems to find the results wrong even if I wrote it like this:

ExamsResult = Var _count = COUNTX(FILTER(ALL('Sheet1'), 'Sheet1'[Subject] = MAX(Sheet1[Subject]) && Sheet1[Exam Result] = "Passed"),[Exam Result]) RETURN IF(_count = BLANK(),"Failed","Passed")

I just tried to filter the passed instead, and reversed the return Failed if true, and Passed if false.
It seems it doesnt work like I thought it would be.
It Resulted to this:

To make it clear, I want to add another filter to make the result show it like this:

by using this new table:

Im sorry, I am new about this. I hope I explained my new problem properly. Thank you very much.