Forum Discussion

Ramendra's avatar
Ramendra
Helper IV
6 years ago
Solved

conditional count

Hi Team,

 

Can some one please help me to get distinct count of "column A" if column b contains text as "positive".

Please find sample data below . I am unable to find formula.

 

Column A	Column B
a	positive
a	positive
a	positive
a	positive
a	positive
b	Negative
b	Negative
b	Negative
b	Negative
b	Negative
b	Negative
c	Positive
c	Positive
c	Positive
c	Positive
c	Positive
c	Positive

 

2 Replies

  • az38's avatar
    az38
    Community Champion

    Ramendra 

    try

    = CALCULATE(DISTINCTCOUNT('Table'[Column A]), 'Table'[Column B]="positive")