Forum Discussion
New column with Grouped Rowcount
Hi,
I have data like this:
| ID | Category |
| A | C1 |
| A | C2 |
| A | C2 |
| B | C1 |
| B | C1 |
| B | C2 |
I want an extra column with the rowcount for Category C1 within each group. So that I get a result like this:
| Group | Category | Category C1 Count |
| A | C1 | 1 |
| A | C2 | 1 |
| A | C2 | 1 |
| B | C1 | 2 |
| B | C1 | 2 |
| B | C2 | 2 |
I only got this far:
CountValues = CALCULATE (COUNTROWS(Table), Table[Category] ="C1"). But this simply puts a 1 when the row category is C1.. it should be pretty easy but I can't find my answer anywhere..
Anonymous , Try a new Measure like
calculate(COUNTROWS(Table), filter(allselected(Table) , Table[Group] = max(Table[Group]) && Table[Category] ="C1"))
3 Replies
- amitchandak
Super User
Anonymous , Try a new Measure like
calculate(COUNTROWS(Table), filter(allselected(Table) , Table[Group] = max(Table[Group]) && Table[Category] ="C1"))amitchandak Thank you for your reply! As a measure I see that it works, but I need is as a column, is there a posibility you think?
