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")
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 months ago

Hi,

Try this measure

Issue = if(CALCULATE(COUNTROWS(Data),FILTER(values(Data[Colour]),CONTAINSSTRING(Data[Comments],"UNKNOWN" )))>0,"Yes","No")
  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    8 months ago

    You are welcome.