help with table and calculation

[Anonymous]

Hello

I am having trouble creating a table or chart that can show me how many people called for the same issue 2 times, 3 times and more than 3 times per month (iN jUNE, JULY and the August) . Thank you so much in advance!

Here is a sample data:

data

I was thinking to show something like this:

[Anonymous]

Hi @Anonymous 

It'll be much easier if your sample data could be copied and pasted.

Cheers!
A

[Anonymous]

I added the same table here:

Issue Name   Date      Person Name

category 1	19-Jul	Mavi
category 2	19-Jul	Jose
category 3	19-Jul	Miriam
category 4	19-Jul	Miriam
category 5	19-Jul	Tom
category 5	19-Jul	Tom
category 5	19-Jul	Tom
category 5	19-Jul	Paul
category 1	19-Jun	Paul
category 2	19-Jun	Carla
category 3	19-Jun	Ana
category 4	19-Jun	Ana
category 4	19-Aug	Ana
category 4	19-Aug	Ana
category 6	19-Aug	Jose
category 6	19-Aug	Jose
category 6	19-Aug	Jose

Thank you!!

---

@Anonymous wrote:

Hi @Anonymous 

It'll be much easier if your sample data could be copied and pasted.

Cheers!
A

---

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[Anonymous]

Hi @Anonymous 

Here are the steps for your requirement:

1. Create a month number column.

In edit query mode, add a new column and type this code

Date.Month([Date])

2. Add an index column. Under add column menu item, press add index. This is just to show all rows with duplicates.

3. Create a new custom column. DAX is:

Count =
CALCULATE (
    COUNTROWS ( T25 ),
    FILTER ( T25, T25[Issue] = EARLIER ( T25[Issue] ) ),
    FILTER ( T25, T25[Month Number] = EARLIER ( T25[Month Number] ) )
)

Now, you have the table with the relevant counter.
First Solution

Not sure if you want to count individuals or a general number of calls.

Anyhow, I think this is 90% of the solution if not a whole one.

Cheers!
A

[Anonymous]

Thank you for your help on this. It's a little close from what I wanted. I was looking into something that can show the counts of patients name that shows up in the list more than 2, 3 and 4 or more times. So for example, if Tom and Jose shows 3 times in the list, then I want a table that shows in one column the count of all the people whose names shows 3 times  (in this case 2 people) and then another column that shows how many times each of those names shows in the list (in this case each person shows 3 times). And then the same for those that shows 2 times,and 4 times or more. In power bi I did it with a table visual but it brings me all the names of the people and then it repeats the counts for each name which makes my table pretty long and hard to read. 

Something like this:

Count of People Times Called

2

3