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

Count( if column value = string)
05-30-2024
11:10 PM
I have a column named Placement containing mixed data values of
N/A
NO PLACMENT
the client name, or
blank
I would like a total count for each individual data value.
How can I achieve this please? a dax formula for Count( if column value = string)?
TIA
Solved! Go to Solution.
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-31-2024
08:26 AM

You can just drop the placement column again and summarized as count.
and measure if need it would be
Placement Count = COUNTA(MyTable[Placement])
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-31-2024
08:26 AM

You can just drop the placement column again and summarized as count.
and measure if need it would be
Placement Count = COUNTA(MyTable[Placement])

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.

Featured Topics
Top Solution Authors (Last Month)
User | Count |
---|---|
90 | |
80 | |
58 | |
46 | |
40 |
Top Kudoed Authors (Last Month)
User | Count |
---|---|
115 | |
81 | |
81 | |
52 | |
39 |