cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
teaguejs
Helper II
Helper II

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

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

1 REPLY 1
Samarth_18
Super User
Super User

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


If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin


Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show episode 9

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 25

Ted's Dev Camp - August 25, 2022

Watch Session 25 of Ted's Dev Camp.

Top Solution Authors