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

Pragati11's avatar
Pragati11
Super User
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

HenryJS's avatar
HenryJS
Post Prodigy
6 years ago

thanks Pragati11 

 

How can I add another filter so that [Action Name] = "Call - Update"?

 

When I tried the below it said does not support comparing values of type true/false and text?

 

 

Count_Calc = CALCULATE(COUNT('Merge1'[CandidateRef]), FILTER(ALL('Export Actions'), [Contacted Since Monday] = "Yes" & [ActionName]="Call - Update"))
  • Pragati11's avatar
    Pragati11
    Super User
    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