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

[Anonymous]

Hi,

I want to create a measure that counts the number of rows in a table that contains a value from one column, that is filtered by values from another column.

So, I'd like to know How many Event "A" there are that have Criteria of "A" or "C" - so in this example it would = 2. 

Thanks!

Soph

[Nathaniel_C · Accepted solution]

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

[Nathaniel_C · Accepted solution]

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

[Anonymous · Accepted solution]

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

[Anonymous]

Ignore - it's working now!

[Nathaniel_C]

Hi @Anonymous ,
IF should be lower case. if

[Nathaniel_C]

hi @Anonymous ,

You can create a column in Power Query and then sum that column in a measure.

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

[Nathaniel_C]