Trying to filter for any rows that contain a list of values in a column

[teaguejs]

Hi, I have a column that contains strings, for example "CVE-2017-11882". I am trying to return all rows where it has any of the following values in that specific column titled "CVE-ID":

CVE-2021-22900
CVE-2021-26855
CVE-2021-26857
CVE-2021-26858
CVE-2021-27065
CVE-2021-27101
CVE-2021-27102
CVE-2021-27103
CVE-2021-27104

[Samarth_18]

Hi @teaguejs 

Please try this:-

measure =
COUNTROWS (
    FILTER (
        "table",
        'table'[CVE-ID]
            IN {
            "CVE-2021-22900",
            "CVE-2021-26855",
            "CVE-2021-26857",
            "CVE-2021-26858",
            "CVE-2021-27065",
            "CVE-2021-27101",
            "CVE-2021-27102",
            "CVE-2021-27103",
            "CVE-2021-27104"
        }
    )
)

Thanks,

Samarth