cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
zmb12
Regular Visitor

Counting the number of distinct values against each entry

Hello. I'm trying to visually display the number of services each person in my company is using. My table is something like this:

Name            Service

A                      B

A                      C

A                      D

B                       E

B                       F

 

I think I first have to create a new column which contains a count of the number of unique entries in the Name column but its not giving the right result

1 ACCEPTED SOLUTION

Accepted Solutions
Super User IV
Super User IV

Re: Counting the number of distinct values against each entry

Hello @zmb12 

This measure will give you the distinct count of services

Service Count = DISTINCTCOUNT ( YourTable[Service] )

Then you pull the name from the table and this measure into your matrix to get your count.

ServiceCount.jpg

View solution in original post

3 REPLIES 3
Super User IV
Super User IV

Re: Counting the number of distinct values against each entry

Hello @zmb12 

This measure will give you the distinct count of services

Service Count = DISTINCTCOUNT ( YourTable[Service] )

Then you pull the name from the table and this measure into your matrix to get your count.

ServiceCount.jpg

View solution in original post

zmb12
Regular Visitor

Re: Counting the number of distinct values against each entry

If it's a table of 100 names, is there a way of avoiding pulling each name individually?

Super User IV
Super User IV

Re: Counting the number of distinct values against each entry

You just drag the name field into the visual, not the name themselves.  It will bring all the names at once.

Names.jpg

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors