Forum Discussion
Solved
Counting Text Values with Multiple filters
Hi there, Please could I ask for some help with a count? I need to perform a really simple count of text values in a range. E.g. I have a column in a dataset called 'Category', this is a text val...
Try this measure:
Security Incidents = CALCULATE ( COUNT ( 'All EV Incidents'[Category] ), 'All EV Incidents'[Category] IN { "Audits", "Qualys", "Branch Raid", "Data Loss", "Denial of Service", "Internal threat", "Lost or Stolen device", "Malware", "PCI", "Ransomware", "Security-Other", "Third Party Supplier", "Website Exploit", "Pen Testing", "SecHQ", "Threat Intelligence" } )
Try this measure:
Security Incidents =
CALCULATE (
COUNT ( 'All EV Incidents'[Category] ),
'All EV Incidents'[Category]
IN {
"Audits",
"Qualys",
"Branch Raid",
"Data Loss",
"Denial of Service",
"Internal threat",
"Lost or Stolen device",
"Malware",
"PCI",
"Ransomware",
"Security-Other",
"Third Party Supplier",
"Website Exploit",
"Pen Testing",
"SecHQ",
"Threat Intelligence"
}
)
Thanks DataInsights. I can see what I did wrong, I messed up the syntax in the COUNT section by not including the second 'All EV Incidents'[Category]) line. Thanks again for the help.