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 Colum...
  • az38's avatar
    6 years ago

    Ramendra 

    try

    = CALCULATE(DISTINCTCOUNT('Table'[Column A]), 'Table'[Column B]="positive")
  • FrankAT's avatar
    6 years ago

    Hi Ramendra ,

    see figure:

     

     Regards FrankAT