Count *text string* match between 2 tables

Hi PBIsteven77 

Try these measures:

Count of Instance = 
CALCULATE (
    COUNTROWS ( 'Description' ),
    FILTER (
        'Description',
        CONTAINSSTRING (
            'Description'[Elixhauser Variable Description (CD)],
            SELECTEDVALUE ( Variable[Variable] )
        )
    )
)

Count of Instance2 = 
SUMX (
    ADDCOLUMNS (
        SUMMARIZE ( Variable, Variable[Variable] ),
        "@instance",
            CALCULATE (
                COUNTROWS ( 'Description' ),
                FILTER (
                    'Description',
                    CONTAINSSTRING (
                        'Description'[Elixhauser Variable Description (CD)],
                        [Variable]
                    )
                )
            )
    ),
    [@instance]
)

The first one returns the total matching rows from Description. The second one will return the total of individual rows.

Thank you for these. They were also giving me the same result. So i disconnected the relationship with the 2 tables, and the issue went away. Bone-headed mistake on my part. Thank you for hte quick response!