Forum Discussion
Solved
CountRows help
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 c...
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.