Forum Discussion

New Member

4 years ago

Solved

Calculated column

Number of ones for the name CC =
COUNTROWS (
    FILTER ( tbl1, tbl1[Name] = EARLIER ( tbl1[Name] ) && tbl1[Status] = 1 )
)

Super User

Number of ones for the name CC =
COUNTROWS (
    FILTER ( tbl1, tbl1[Name] = EARLIER ( tbl1[Name] ) && tbl1[Status] = 1 )
)