Forum Discussion

MJG2112's avatar
MJG2112
Icon for Advocate II rankAdvocate II
8 months ago
Solved

Looking Up a Partial Value in a Column

Hi.  I'm trying to do something that on the face if it seems simple enough, but I'm struggling.  I've had to create some simple mock data as I can't share the real thing.  I have a visual showing man...
Need Help
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 months ago

    Hi,

    Try this measure

    Issue = if(CALCULATE(COUNTROWS(Data),FILTER(values(Data[Colour]),CONTAINSSTRING(Data[Comments],"UNKNOWN" )))>0,"Yes","No")
GeraldGEmerick's avatar
GeraldGEmerick
Icon for Memorable Member rankMemorable Member
8 months ago

MJG2112 You should be able to use CONTAINS, like:

Contains Unknown = CONTAINS( 'Data', [Comments], "UNKNOWN" )

Or maybe:

Contains Unknown = CONTAINSSTRING( CONCATENATEX( 'Data', [Comments], "," ), "Unknown" )