Calculate with multiple filters

[Michie_24]

Hi everyone, I am trying to calculate a percentage here by using the CALCULATE function with multiple filters. Here is the dax code that I have written. This measure works as it should, but it takes time to load. I am wondering if there is another way of writing the DAX for better performance?

% of hires within 15 workdays = 

VAR NoHiresWithin15WorkDays = CALCULATE(countrows(filter(Request,Request[Hired within 15 Workdays]="Yes")),FILTER(REQUEST, Request[AcceptanceDt]<>BLANK() && [Candidate Confirmed Date]<>BLANK() && Request[RPI2 - DateFlag by RequestID]=tRUE() && [Feedback Workdays by requestID]<=5))

var requestidcount = CALCULATE(COUNT(Request[RequestID]), FILTER(REQUEST, Request[AcceptanceDt]<>BLANK() && [Candidate Confirmed Date]<>BLANK() && Request[RPI2 - DateFlag by RequestID]=tRUE() && [Feedback Workdays by requestID]<=5))

RETURN

NoHiresWithin15WorkDays/requestidcount

Thank you in advance!

[V-pazhen-msft · Accepted solution]

@Michie_24 

Try use IF instead of add multiple filters.

% of hires within 15 workdays = 
VAR NoHiresWithin15WorkDays = IF([AcceptanceDt]<>BLANK()
                                    &&　[Candidate Confirmed Date]<>BLANK()
                                        &&　RPI2 - DateFlag by RequestID]=TRUE()
                                            &&　[Feedback Workdays by requestID]<=5,
                                            countrows(filter(Request,Request[Hired within 15 Workdays]="Yes")))
var requestidcount =IF([AcceptanceDt]<>BLANK() 
                        && [Candidate Confirmed Date]<>BLANK() 
                            && [RPI2 - DateFlag by RequestID]=ＴRUE() 
                                && [Feedback Workdays by requestID]<=5,
                                    COUNT(Request[RequestID])
RETURN
NoHiresWithin15WorkDays/requestidcount

Best regards
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.