Counting text across multiple columns

Question

Hi, I'm brand new to PowerBI this week!&nbsp;I have a risk data set, within which there are 10 control columns in which the responses are either "complete", "slipped", "limited" or "on track" or left blank. I have created a table for my report which lists the risks out in the rows, and then I want to have 4 columns in the table to show the count of the number of controls that are "complete", "slipped", "limited" or "on track".For example:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Complete&nbsp; &nbsp; On Track&nbsp; &nbsp; Limited&nbsp; &nbsp; SlippedRisk 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1Risk 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp;What DAX expression should I use to count how many are complete, how many are on track etc?Thank you!

jennaexe · Accepted Answer

I don't know. In the end I decided the simplest solution was to go back to the original data set, and create a table that combined all the different columns into a single table, where it was then much easier to count what I wanted it to count in BI.

Forum Discussion

Counting text across multiple columns

2 Replies

Related content

Count across multiple columns

count values from multiple columns

Count from multiple columns

distinct count of multiple columns

Total Count in Column