Reply
Topic Options
- 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
Problems with dax count for table with text
11-20-2023
04:15 AM
Hi,
I am trying to count the total # rows in a table for a specific column (plus another 2 calcs):
adverse_sus_ind_#_rows = COUNTROWS(FILTER(equty_report_table, equty_report_table[adverse indicator]))
However, the result is blank. This column contains fields with text (format), but also numbers, %, etc. What am I doing wrong? Why do I just get blank when there around 450 records with text in? Would it make more sense just to use a filter (keeping in mind that I need to also do this based on %)?
I need to do 3 things, total # rows (all rows, about around 450 + 200 blanks, so no text in the fields), and then # of rows with text (content) and # rows without content (blank). On top of that, I need to show what that is in % (so how many lines are blank / no content).
This is for a data quality dashboard.
Cheers,
Carsten
Solved! Go to Solution.
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-20-2023
05:49 AM
hi @cmfaarvang ,
try like:
measure1 = COUNTROWS(FILTER(equty_report_table, equty_report_table[adverse indicator]=BLANK()))
measure2 = COUNTROWS(FILTER(equty_report_table, equty_report_table[adverse indicator]<>BLANK()))
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-20-2023
05:49 AM
hi @cmfaarvang ,
try like:
measure1 = COUNTROWS(FILTER(equty_report_table, equty_report_table[adverse indicator]=BLANK()))
measure2 = COUNTROWS(FILTER(equty_report_table, equty_report_table[adverse indicator]<>BLANK()))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-21-2023
03:06 AM
Thanks a lot for that, did not think of that, works great.

Helpful resources
Announcements
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Recommendations
Subject | Author | Posted | |
---|---|---|---|
03-20-2024 11:05 PM | |||
Anonymous
| 06-06-2024 12:04 AM | ||
01-24-2024 08:48 AM | |||
04-12-2023 07:54 PM | |||
07-20-2024 11:19 AM |
Top Solution Authors (Last Month)
User | Count |
---|---|
22 | |
12 | |
10 | |
10 | |
8 |
Top Kudoed Authors (Last Month)
User | Count |
---|---|
15 | |
15 | |
15 | |
12 | |
10 |