Measure: Count IF Measure = Yes

[HenryJS]

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]

<> BLANK ()

&& MAX ( [action.date] ) >= [lastMonday]

&& MAX ( [ActionName] ) in {"Call - Update", "Email - General Email", "Email - Follow up", "Email - Get In Touch"},

"Yes",

"No"

)

[Pragati11 · Accepted solution]

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

[Anonymous]

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"))

[Pragati11 · Accepted solution]

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]

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 · Accepted solution]

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