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 g...
Anonymous , Try a new Measure like
calculate(COUNTROWS(Table), filter(allselected(Table) , Table[Group] = max(Table[Group]) && Table[Category] ="C1"))
amitchandak
Super User
Super UserAnonymous , 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?
Ah, I just used the measurement to add as a colum and that works perfectly :)!