New column with Grouped Rowcount

[Anonymous]

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..

[amitchandak · Accepted solution]

@Anonymous , Try a new Measure like

calculate(COUNTROWS(Table), filter(allselected(Table) , Table[Group] = max(Table[Group]) && Table[Category] ="C1"))

[Anonymous]

@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?

[Anonymous]

Ah, I just used the measurement to add as a colum and that works perfectly :)!