Count IF

[HenryJS]

Hi all,

How can I Count 'CandidateMeritID' if 'Detail1DropDownValue' = "No"?

Thanks,

[v-eachen-msft · Accepted solution]

Hi @HenryJS ,

You could refer to this measure:

Measure = 
CALCULATE(COUNT('Table'[CandidateMeritID]),FILTER('Table','Table'[Detail1DropDownValue]="No"))

Measure =
COUNTROWS(FILTER('Table','Table'[Detail1DropDownValue]="No"))

Or create a calculated column:

Column =
IF('Table'[Detail1DropDownValue]="No",1,0)

[amitchandak]

New measure like =Countx(filter(table,'Detail1DropDownValue' = "No"),table[CandidateMeritID])