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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.