Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
Best Regards,
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |