Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
Varan_15
Helper III
Helper III

how to get text count

Hi ,

 

How to i get text column unique values count (for example Status column have unique text values how to get total count)

Capture11.PNG

 

1 ACCEPTED SOLUTION
ddpl
Solution Sage
Solution Sage

@Varan_15  try this

 

Column or Measure = CALCULATE(COUNTX('Table','Table'[Status]),all('Table'[id]))
 

View solution in original post

3 REPLIES 3
v-luwang-msft
Community Support
Community Support

Hi @Varan_15 ,

You could download my file to learn detail operations:

vluwangmsft_0-1669884079596.png

 

 

 

Best Regards

Lucien

ddpl
Solution Sage
Solution Sage

@Varan_15  try this

 

Column or Measure = CALCULATE(COUNTX('Table','Table'[Status]),all('Table'[id]))
 

@ddpl ,

 

Great it's working as expected. thanks

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors