Forum Discussion
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.
NathanielThanks 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
Community ChampionHi 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
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
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
Ignore - it's working now!
- Nathaniel_C
Hi Anonymous ,
IF should be lower case. if