CountRows help

[FlappyRabbit]

I have a table with US states in Column A and then 10 columns headed with different animals. I have a "y" in the table if that animal is found in that state, how do I create a new column/measure to count how many "y"'s for each state (row) please??

[HotChilli]

That's fine. If you have skills in Excel that's the place to solve an issue.

[HotChilli]

In Power Query, you could add a column using List.Select(, for example,

List.Select({[Column1],[Column2],[Column3]}, each _ = "y"))

and you can wrap that with a List.Count to count the "y"'s

----

However, the most flexible solution would probably be to Unpivot all the Animal columns (in Power Query) and write a single DAX measure using COUNT.

[FlappyRabbit · Accepted solution]

Thanks, I get erros when I enter the code (likely my error as totally new to DAX/coding...). I used a COUNTIFS formula in the Excel source file instead in the end which achieved the same goal.