Forum Discussion
Check if there is a particular value
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.
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 👍
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.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.
Wow! Thank you so much it works! Will have to study about Filter and Allselected functions.
