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 need to count multiple times a domain appears in a column and give that count.
For example
| hotmail.co.uk | 
| googlemail.com | 
| googlemail.com | 
| googlemail.com | 
| hotmail.co.uk | 
| hotmail.co.uk | 
| hotmail.co.uk | 
| hotmail.co.uk | 
| googlemail.com | 
| googlemail.com | 
| googlemail.com | 
| googlemail.com | 
| hotmail.com | 
| hotmail.com | 
| hotmail.com | 
| hotmail.com | 
| hotmail.com | 
| gmail.com | 
| bpp.com | 
| hotmail.co.uk | 
| googlemail.com | 
| outlook.com | 
How many times does gmail.com, hotmail.com, outlook.com... appear and so on. I can not set up a COUNT for each as the imported data have some 28k+ lines an I dont want to miss any domains
Solved! Go to Solution.
 
					
				
		
Hi @AdyF ,
2. Or create a measure:
Count = COUNTROWS('Table')3. Or create a new table:
New Table = SUMMARIZE('Table','Table'[Column1],"Count", COUNTROWS('Table')) 
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
 
					
				
		
Hi @AdyF ,
2. Or create a measure:
Count = COUNTROWS('Table')3. Or create a new table:
New Table = SUMMARIZE('Table','Table'[Column1],"Count", COUNTROWS('Table')) 
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @AdyF ,
Would DistinctCount (Column) work for you in this instance and then summarize it in a matrix in your report?
 
					
				
				
			
		
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 | 
|---|---|
| 88 | |
| 49 | |
| 37 | |
| 31 | |
| 30 |