Forum Discussion

MJG2112's avatar
MJG2112
Icon for Advocate II rankAdvocate II
9 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
    9 months ago

    Hi,

    Try this measure

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

Hi MJG2112,

 

If your visual already has Month and Product in the context, you can simplify:
 
HasUnknown =
IF(
    CONTAINSSTRING('YourTable'[Comments], "UNKNOWN"),
    "Yes",
    "No"
)
 

If this response was helpful in any way, I’d gladly accept a 👍much like the joy of seeing a DAX measure work first time without needing another FILTER.

Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop 🌀.