Create measure to count rows based on value in one column that is filtered by another column

Hi Anonymous ,

if [#"Criteria "] = "A" and [#"Type of Event"] = "A" or [#"Criteria "] = "C" and [#"Type of Event"] = "A" then 1 else 0

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

Thanks Nathaniel!

It's almost working - just this weird error with then and else:

Any ideas? I added "#" before "Seriousness Criteria" but that throws up an "invalid identifier" error