Trying to count the number of times a value from one column appears while filtered a certain way

[Anonymous]

Data looks like this:

Column A           Column B

asdf                     no

adsf                     yes

adsf                     no

czcz                     yes

czcz                     yes

I want to count the "yes" values and i want to add a calculated column (Column C) that looks like this below where the # of yes's for a given value in column A is shown for all of those values if it repeats:

Column A        Column C

asdf                     1

adsf                     1

adsf                     1

czcz                     2

czcz                     2

Thanks in advance...

[mahoneypat · Accepted solution]

Please try this column expression, replacing Table with your actual table name.

Yes Count =
CALCULATE (
    COUNT ( Table[ColumnA] ),
    ALLEXCEPT (
        Table,
        Table[ColumnA]
    ),
    Table[ColumnB] = "yes"
)

Regards,

Pat

[Ashish_Mathur · Accepted solution]

Hi,

Try his calculated column formula

=CALCULATE(CALCULATE(COUNTROWS(Data),Data[Reply]="yes"),FILTER(Data,Data[Text]=EARLIER(Data[Text])))

Hope this helps.

[mahoneypat · Accepted solution]

Please try this column expression, replacing Table with your actual table name.

Yes Count =
CALCULATE (
    COUNT ( Table[ColumnA] ),
    ALLEXCEPT (
        Table,
        Table[ColumnA]
    ),
    Table[ColumnB] = "yes"
)

Regards,

Pat