Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
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.
You can just drop the placement column again and summarized as count. 
and measure if need it would be 
You can just drop the placement column again and summarized as count. 
and measure if need it would be 
 
					
				
				
			
		
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
 
            | User | Count | 
|---|---|
| 80 | |
| 49 | |
| 35 | |
| 31 | |
| 30 |