RE: Distinct Count Question

[residentx]

I have a list of customers. Also, I created a column inside of this list with letters (A-Z) to see how many companies are in which letter. Unfortunately, I used the distinct count but I cannot get the info I need. Any comments?

I want the results to look like this:

A - 100

B  - 25

C - 55

but I got 26 distinct count and aggregate count was 560.

[Greg_Deckler]

If you have something like:

Customer,Letter

Create a measure like:

NumberOfCustomers = COUNT([Customer])

Create a table visualization and put Letter and NumberOfCustomers in it.

[residentx]

My Colums are these:

Name, Letter

I created the measure but the table visualization I couldn't get to work right. I use the card and filtered it for the letter I need and it showed the number I wanted. If I need 26, then I guess I need to create 26 cards and resize them. The measure worked nicely though if only I could find a way to make it twist easier. I would like to be able to click letters and have it show numbers.

I need to watch more videos 🙂

[v-shex-msft]

Hi residentx,

Smoupre’s point seems well, I’d like to share other way to achieve your requirement:

1. Add a tables visual.

 

1. Right-Click on name column, and choose summarize option count:

 

In addition, if you want to display the specify item(e.g. a, b, c), you could add a slicer to filter the data.

 

Result:

 

Regards,

Xiaoxin Sheng

[residentx]

Xiaoxin,

What version of powerBI are you using? I don't have the slicer in version, Version: 2.37.4464.602 64-bit (July 2016)

[Greg_Deckler]

The slicer visual has always been there. If you are using the card visualization, you could have a single measure but just filter each one by the letter that you want. I'm not sure what could possibly have gone wrong with a table visualization.

[residentx]

I can see the visuals but they are two separate ones. Can we "chain" visuals in Powerbi now?

[Greg_Deckler]

Yes, you have always been able to chain visuals together in Power BI.

[residentx]

I think I'm tired today. Let me look at this when I'm fresh. The table allowed me to do some things but not everything I wanted.