Skip to main content
cancel
Showing results for 
Search instead 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

Reply
HenryJS
Post Prodigy
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
Pragati11
Super User
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


MVP logo


LinkedIn | Twitter | Blog YouTube 

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

Appreciate your Kudos!!

Proud to be a Super User!!

View solution in original post

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


MVP logo


LinkedIn | Twitter | Blog YouTube 

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

Appreciate your Kudos!!

Proud to be a Super User!!

View solution in original post

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

 

Pragati11
Super User
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


MVP logo


LinkedIn | Twitter | Blog YouTube 

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

Appreciate your Kudos!!

Proud to be a Super User!!

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

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


MVP logo


LinkedIn | Twitter | Blog YouTube 

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

Appreciate your Kudos!!

Proud to be a Super User!!

Helpful resources

Announcements
Europe Fabric Conference

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 Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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