Forum Discussion

AshwinC's avatar
AshwinC
Frequent Visitor
4 years ago
Solved

Filter with Text Contains

Hi All,   I have Column which has muliple Values   Option Type Date1 Date 2 Option1, Option2, Option3 10/02/2022 12/02/2022 Option1, Option3 15/01/2022 16/01/2022 Option2 18/01...
Need Help
  • MFelix's avatar
    MFelix
    4 years ago

    Hi AshwinC ,

     

    Believe the best option is to make a transformation on the query editor and split those options by row:

    This will allow to have the final result directly on your table.

     

    If this is not possible then you can try to do the following:

    • Create a disconnected table with all your options
    • Then create the following measure

     

    CountRows = 
COUNTROWS (
    FILTER (
        ADDCOLUMNS (
            'Table (2)',
            "StringFind", CONTAINSSTRING ( 'Table (2)'[Option Type], SELECTEDVALUE ( Options[Options] ) )
        ),
        [StringFind] <> BLANK ()
    )
)

     

     

     

    Regarding the second value you present how is it calculated?

     

     

MFelix's avatar
MFelix
Super User
4 years ago

Hi AshwinC ,

 

Believe the best option is to make a transformation on the query editor and split those options by row:

This will allow to have the final result directly on your table.

 

If this is not possible then you can try to do the following:

  • Create a disconnected table with all your options
  • Then create the following measure

 

CountRows = 
COUNTROWS (
    FILTER (
        ADDCOLUMNS (
            'Table (2)',
            "StringFind", CONTAINSSTRING ( 'Table (2)'[Option Type], SELECTEDVALUE ( Options[Options] ) )
        ),
        [StringFind] <> BLANK ()
    )
)

 

 

 

Regarding the second value you present how is it calculated?