Forum Discussion
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 how many "Yes" records are in each row, or Ho many "No information" available records.
Below is the table I am working on:
Please guide me if there is a way to calculate count using DAX
Thank you!
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.
4 Replies
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.
Thanks so much for your quick replay, worked very well!
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!
