Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Multiple filters in one column

Hello There!

 

I am trying to create a measure where i am trying to find the percentage also applying multiple filters in one column. 

 

% Female New Hire = calculate(
Sum('NH PFF%'[Position Fit For Females]),
FILTER('NH PFF%', 'NH PFF%'[HR Country New] = "Algeria" &&'NH PFF%'[HR Country New] = "Bahrain" &&'NH PFF%'[HR Country New] = "Egypt" &&'NH PFF%'[HR Country New] = "Iran" &&'NH PFF%'[HR Country New] = "Jordan" &&'NH PFF%'[HR Country New] = "Lebanon" &&'NH PFF%'[HR Country New] = "Qatar" &&'NH PFF%'[HR Country New] = "Saudi Arabia" &&'NH PFF%'[HR Country New] = "United Arab Emirates")
/ SUM('NH PFF%'[Total Hires]))
 
I am getting the below error.  
 
A function 'FILTER' has been used in a True/False expression that is used as a table filter expression. This is not allowed.
 
Could someone please guide me where i am going wrong. 
 
Cheers!
Ashraf 
Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    Anonymous , Try like

     

    % Female New Hire = Divide(
    calculate( Sum('NH PFF%'[Position Fit For Females]),
    FILTER('NH PFF%', 'NH PFF%'[HR Country New] in{ "Algeria", "Bahrain", "Egypt" , "Iran" , "Jordan", "Lebanon" , "Qatar", "Saudi Arabia", "United Arab Emirates"))
    , SUM('NH PFF%'[Total Hires]) )