Forum Discussion

iping's avatar
iping
New Member
5 years ago
Solved

Filtering Data by containing string values

Figure 1.0 - design screen above is shown of my report.   I collected data shown in the table for preference of colors - the results are shown eg. Red, Yellow for the participants in survey.  ...
Interesting Links
Need Help
Tutorial Requests
  • Icey's avatar
    Icey
    5 years ago

    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.

Icey's avatar
Icey
Icon for Community Support rankCommunity Support
5 years ago

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.