cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Post Prodigy

## 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]
<> BLANK ()
&& MAX ( [action.date] ) >= [lastMonday]
&& MAX ( [ActionName] ) in {"Call - Update", "Email - General Email", "Email - Follow up", "Email - Get In Touch"},
"Yes",
"No"
)
2 ACCEPTED SOLUTIONS
Super User

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

Best Regards,

Pragati Jain

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Proud to be a Super User!!

Super User

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

Best Regards,

Pragati Jain

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Proud to be a Super User!!

4 REPLIES 4
Anonymous
Not applicable

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

Super User

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

Best Regards,

Pragati Jain

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Proud to be a Super User!!

Post Prodigy

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

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

Best Regards,

Pragati Jain

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Proud to be a Super User!!

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors