Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 | |
3.5.23 | Mary | Bing |
3.7.23 | Tom | Yahoo |
3.1.23 | Joe | |
3.5.23 | Mary | Bing |
3.7.23 | Tom | Yahoo |
Solved! Go to 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
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
@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
@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
User | Count |
---|---|
96 | |
85 | |
77 | |
66 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |