Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

Counting multiple filters with one of them containing some words

Hello everyone, 

 

I need to make a Measure that counts the number of candidates in a folder which I did succesfully so far but I need to add a filter for the reasons why they are in that folder. There are multiple reasons that starts with "Bewerbung:" and I need to count the candidates that have them. So far I got to this code: 

 

Screening - Regret = CALCULATE(COUNTAX('Folder Movement', [Value.2]),'Folder Movement'[Attribute]="Candidate Folder history_Screening - Not Interested" && FILTER('outcomes', FIND ("Bewerbung:”, 'outcomes'[ScreeningRejectReasonDE],, 0) <> 0))
 
But it doesn't work. The code that works without the containing word filter is: 
 
Screening - Regret = CALCULATE(COUNTAX('Folder Movement', [Value.2]),'Folder Movement'[Attribute]="Candidate Folder history_Screening - Not Interested")
 
Do you have any ideas on what i'm doing wrong?
 
Thank you very much,
Ovidiu 
4 REPLIES 4
Anonymous
Not applicable

This is the error i'm receiving: 

 

PBIDesktop_IOc3BDw94V.png

Anonymous
Not applicable

I tried also with , instead of && 

 

DE Filtered Screening - Regret = CALCULATE(COUNTAX('Folder Movement', [Value.2]),'Folder Movement'[Attribute]="Candidate Folder history_Screening - Not Interested", FILTER('outcomes', FIND("Bewerbung:”, 'outcomes'[ScreeningRejectReasonDE],, 0) <> 0)
 
PBIDesktop_ar3WgN4Tby.png
Anonymous
Not applicable

@Anonymous 
In case you have shared complete syntax
One closing paranthesis for calculate function is missing. Put one more closing paranthesis at the end and if it does not work please share some data.

Anonymous
Not applicable

Nope, i've tried. It adds a lot of paranthesis at the end by itself too. 

 

Is there any additional info I can give? 

 

PBIDesktop_YbWb0AmHWc.png

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Users online (841)