Forum Discussion
help with table and calculation
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
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
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