Forum Discussion
Count by category
Carliniiiii , You can use Summarize function for this and create a new table by going into modelling section
NewTable =
SUMMARIZE(
'YourTableName',
'YourTableName'[Location],
"Frequency", COUNTROWS(SUMMARIZE('YourTableName', 'YourTableName'[Project], 'YourTableName'[Location]))
)Carliniiiii , Create another table using
GroupedData =
SUMMARIZE(
YourTableName,
YourTableName[Location],
YourTableName[Response],
"Frequency", COUNT(YourTableName[Response])
)
bhanu_gautam , I have another question in a similar format.
I have following table:
| Location | Quarter | Response |
| A | Q1 | Yes |
| A | Q2 | No |
| A | Q3 | No |
| A | Q4 | Yes |
| B | Q1 | No |
| B | Q2 | Yes |
| B | Q3 | Yes |
| B | Q4 | Yes |
And I would like it to be grouped by both location as well as yes/no answers. I have limited the example to one year only but it should work over multiple years.
| Locations | Response | Frequency |
| A | Yes | 2 |
| A | No | 2 |
| B | Yes | 3 |
| B | No | 1 |
Many thanks
Super UserCarliniiiii , Create another table using
GroupedData =
SUMMARIZE(
YourTableName,
YourTableName[Location],
YourTableName[Response],
"Frequency", COUNT(YourTableName[Response])
)