Forum Discussion

HenryJS's avatar
HenryJS
Post Prodigy
6 years ago
Solved

Measure: Count IF Measure = Yes

Hi all,   I have the below measure.   How do I create a new measure which Counts 'Export Actions'[CandidateRef] IF [Contacted Since Monday] = "Yes"   Contacted Since Monday = IF ( [name] <...
Data Protection
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Pragati11's avatar
    Pragati11
    6 years ago

    Hi HenryJS ,

     

    You can create a measure something like this:

     

    Count_Calc = CALCULATE(COUNT('Export Actions'[CandidateRef]), FILTER(ALL('Export Actions'), [Contacted Since Monday] = "Yes"))

     

    If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

     

    Thanks,

    Pragati

  • Pragati11's avatar
    Pragati11
    6 years ago

    Hi HenryJS ,

     

    Just modify the DAX to following:

     

    Count_Calc = CALCULATE(COUNT('Merge1'[CandidateRef]), FILTER(ALL('Export Actions'), [Contacted Since Monday] = "Yes" &&[ActionName]="Call - Update"))

     

    If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

     

    Thanks,

    Pragati

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I don't know if I'm missing some information but I think you could create a measure like this:

count = CALCULATE(COUNT('Export Actions'[CandidateRef]), FILTER('otherTable', [contacted since monday] = "Yes"))