Forum Discussion
Solved
Count text value items in row
Good day everyone I have a table in Power BI imported, the number of columns is about 400, and the rows are around 190. I need to calculate text value items for each row separately. for example h...
You would need to do this in Power Query.
Insert a custom column and use following formula to calculate no. of Yes
= List.Count(List.Select(Record.ToList(_),each _="Yes"))For no. of No information
replace Yes with No information in above formula.
Akaki This would be much easier if you unpivoted your Question columns. Otherwise, you are going to need DAX that checks all 400 columns. If you unpivoted, you could simply use something like CALCULATE(COUNTROWS('Table'),[Value] = "yes")
Thanks for the reply, good option as well to solve the issue!