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??
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.
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.
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.
That's fine. If you have skills in Excel that's the place to solve an issue.
