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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Aniket_Bhande
Frequent Visitor

Calculate distinct count

Hi guys, i have data 

IMG20221229120031.jpg

Where I have

customer population.      customer name

0- 20 

22-49

50-99

>100

But we want 

Customer population with no of customer. How we will do that 

 

3 REPLIES 3
Anonymous
Not applicable

Hi @Aniket_Bhande ,

You can create a measure as below to get it and put it on your visual:

Measure = DISTINCTCOUNT ( 'Table'[CUST NAME] )

f the above one can't help you get the expected result, please provide some raw data in your table (exclude sensitive data) with Text format and your expected result with backend logic and special examples. Does the field [customer population] and [customer name] come from the same table? It is better if you can share a simplified pbix file with the expected result explanation. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

Aniket_Bhande
Frequent Visitor

I want result how many customers in each group 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

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