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)

     

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

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

  • v-eachen-msft's avatar
    v-eachen-msft
    Community Support
    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)