Forum Discussion

HenryJS's avatar
HenryJS
Post Prodigy
6 years ago
Solved

Count IF

Hi all,   How can I Count 'CandidateMeritID' if 'Detail1DropDownValue' = "No"?     Thanks,
Need Help
Show and Tell
Tips and Tricks
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    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's avatar
amitchandak
Super User
6 years ago

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