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

Please try the formula below:

 

Product Issue =
VAR HasUnknown =
    CALCULATE (
        COUNTROWS ( 'Table' ),
        FILTER (
            ALL ( 'Table'[Colour] ),
            CONTAINSSTRING ( 'Table'[Comments], "UNKNOWN" )
        )
    )
RETURN
IF ( HasUnknown > 0, "Yes", "No" )