Forum Discussion

tijuemson's avatar
tijuemson
Frequent Visitor
5 years ago
Solved

return Yes or no from column

Download data here    So i am in a pickle i have to find certain customers from a survey results if they fill anything like sucidal or self harm and i need to flag it.   so i used containsstring...
data protection
Need Help
Tips and Tricks
Tutorial Requests
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    Hi tijuemson 

    This Measure will work, but you haven't provided actual data to test against.

     

    Measure = MAX('Table'[Column1])

     

    Doing a MAX on a text column will return "True" if it exists anywhere, otherwise you will get "False".  T comes after F in the alphabet.  This is assuming the column can only contain "True"or "False" as you described.

    Regards

    Phil

nvprasad's avatar
nvprasad
Icon for Solution Sage rankSolution Sage
5 years ago

Hi,

 

Please try with the below dax funtion.

 

Check =
IF (
OR (
CONTAINSSTRING ( Survey[Response], "sucidal" ),
CONTAINSSTRING ( Survey[Response], "self harm" )
)
= TRUE (),
"True",
"False"
)
 

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad

tijuemson's avatar
tijuemson
Frequent Visitor
5 years ago

Hi Prasad,

 

I have done this part.

but now i want to add this to the report.

 

but since i am doing columnwise it only shows the first or last value

 

but i want to return True even if atleast one true is there

 

and if all are no then no

 

thanks