count rows

[Anonymous]

hi,

I have 2 columns and i need to count the number of rows in organization based on the the name

example: i count 3 times school by the name Jay

Thanks

[PattemManohar · Accepted solution]

@Anonymous Please try this as a "New Column"

Count = CALCULATE(COUNTROWS(Test84Count),ALLEXCEPT(Test84Count,Test84Count[Name]))

Note - Please try to post the sample data that can be copied.