Filtering Data by containing string values

Hi iping ,

Try this:

Measure 2 =
IF (
    SUMX (
        ColorTable,
        FIND (
            UPPER ( ColorTable[ChoiceList] ),
            UPPER ( MAX ( ColorsDS[Color Choice] ) ),
            ,
            0
        )
    ) > 0,
    1
)

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.