Stuck trying to figure out how to count the number of items per column. Seems so simple.

[Confusedpbi]

My report needs to count the number of items in each category in a column. 

Here is an example of my data. I need to count the number of times an item shows up under Source. I tried count, but it goves me the total, I tried count disctinct but nothing seems to give me the accurate number. 

What do I need to do to count the number of times Google shows up as a source, the number of times Bing shows up, etc? 

Thank you

Date	Name	Source
3.1.23	Joe	Google
3.5.23	Mary	Bing
3.7.23	Tom	Yahoo
3.1.23	Joe	Google
3.5.23	Mary	Bing
3.7.23	Tom	Yahoo

[v-yangliu-msft · Accepted solution]

Hi  @Confusedpbi ,

Here are the steps you can follow：

1. Create measure.

Measure =
COUNTX(
    FILTER(ALL('Table'),
    YEAR('Table'[Date])=YEAR(MAX('Table'[Date]))&&
    MONTH('Table'[Date])=MONTH(MAX('Table'[Date]))&&
    'Table'[Name]=MAX('Table'[Name])&&'Table'[Source]=MAX('Table'[Source])),
    [Source])

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[amitchandak]

@Confusedpbi , Create a visual with Source as Not Sumamrized field/Axis/Row and use a measure below with that

Count = countrows(Table)

what is the expected output you are not getting

or do you need dynamic segmentation

Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ

[Confusedpbi]

@amitchandak I am trying to see how many leads from each lead source my salesperson received. 

As an example: In March, each salesperson received 20 leads from Google, 10 leads from Bing and 15 leads from Yahoo. 

I want Power BI to show me how many leads each person received from each lead source each month. 

Thank you