I have a question about creating a column in Power BI editor table that counts the number of a specific text value across several columns. See the screenshot below, I would like to count how many of the 4 columns ("Was question 1,2,3,4 resolved"?) have a vlaue of "Yes".
There is an similar question asked in this forum, and the solution is to use the "List.Count(List.Select(Record.FieldValues(_), (x) => Text.Contains(x, "Yes")))" formulae. I tried this in my case, but what I got is just Errors, although the no syntax errors are detected, as shown in the Screenshot below.
I don't know why the formulae does not work in my case, or why it worked in the original case. Is there anyway I can get the count of the values in one step? Thanks.