Can't use FILTER in quick measure twice

[Anonymous]

Good day,

Trying to create quick measure using FILTER command twice, but error "Too many arguments were passed to the FILTER function. The maximum argument count for the function is 2". How to fix it?

The formula itself that I come up with: 

ReportPassed3GI% = CALCULATE(COUNTA(Append_RFO_Details_New[Status]),FILTER(Append_RFO_Details_New,Append_RFO_Details_New[SubGroup]="3GI",FILTER(Append_RFO_Details_New,Append_RFO_Details_New[Status]="Ok")))
/CALCULATE(COUNTA(Append_RFO_Details_New[Personnel ID]))+0

[tamerj1]

Hi @Anonymous 

please try

ReportPassed3GI% =
CALCULATE (
COUNTA ( Append_RFO_Details_New[Status] ),
FILTER (
Append_RFO_Details_New,
Append_RFO_Details_New[SubGroup] = "3GI"
&& Append_RFO_Details_New[Status] = "Ok"
)
)
/ CALCULATE ( COUNTA ( Append_RFO_Details_New[Personnel ID] ) ) + 0

[Anonymous]

Hi Tamer J,

by filter no argument, thanks a lot to you, but I've mistaken only in one part. If we / by Personnel ID, it will count all others as well, and final percent and result will be not quite correct. Can we / to SubGroup only with 3GI values?

[tamerj1 · Accepted solution]

@Anonymous 

Please try

ReportPassed3GI% =
CALCULATE (
COUNTA ( Append_RFO_Details_New[Status] ),
FILTER (
Append_RFO_Details_New,
Append_RFO_Details_New[SubGroup] = "3GI"
&& Append_RFO_Details_New[Status] = "Ok"
)
)
/ CALCULATE (
COUNTA ( Append_RFO_Details_New[Personnel ID] ),
KEEPFILTERS ( Append_RFO_Details_New[SubGroup] = "3GI" )
) + 0

[Anonymous]

It works completely fine! Thank you a lot