- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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 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:
Complete On Track Limited Slipped
Risk 1 3 2 4 1
Risk 2 5 3 2 0
What DAX expression should I use to count how many are complete, how many are on track etc?
Thank you!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
Br
Marius
BI Fabrikken
www.bifabrikken.no

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
10-17-2023 11:08 AM | |||
11-02-2024 09:07 PM | |||
11-12-2024 07:16 AM | |||
11-14-2023 08:05 PM | |||
07-25-2023 01:16 AM |
User | Count |
---|---|
141 | |
117 | |
80 | |
65 | |
47 |