Forum Discussion
Create measure to count rows based on value in one column that is filtered by another column
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
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
6 Replies
- Nathaniel_C
Community Champion
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
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