Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
104 | |
86 | |
73 | |
66 |
User | Count |
---|---|
124 | |
113 | |
98 | |
81 | |
72 |