Forum Discussion
Solved
Counting text across multiple columns
Hi, I'm brand new to PowerBI this week! 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 ...
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.
Hi,
Could you use a matrix visual, and put the risk column on rows, controls on columns and just count something e.x COUNTROWS() on values?
Br
Marius