Forum Discussion
Advocate ICheck if there is a particular value
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!
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.
4 Replies
- Idrissshatila
Super User
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 👍
JofrainVisdaNo 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.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.
