Check if there is a particular value

[JofrainVisda]

Hello friends,

I just made my problem more simple for you to understand it quickly.
I just want to find a way to check if one of the rows from column E has a value of 1 from column F. If yes, proceed to next condition.
In the image below, I would like to check if the letter A,B or C has a value of 1 from column F. If letter A,B or C has a value of 1 from column F, it will not proceed to the next condition. Hope you can help me. Thank you!

[Idrissshatila]

Hello @JofrainVisda ,

yes , its like this   if ( TableName [F] = 1, if( column = second condition),result true,result false)

and here is the syntax by microsoft https://learn.microsoft.com/en-us/dax/if-function-dax

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[JofrainVisda]

No sir. It will only check the current row and not for all the letters.

Example for letter A.
What I need is to check if letter A, regardless of the row, has a value of 1 from column F.

[Anonymous · Accepted solution]

Hi @JofrainVisda ,

What about this measure?

Measure = IF(CALCULATE(SUM('Table'[F]),FILTER(ALLSELECTED('Table'),[E]=MAX('Table'[E])))>0,"next condition","done")

Best Regards,

Stephen Tao

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

[JofrainVisda]

Wow! Thank you so much it works! Will have to study about Filter and Allselected functions.