Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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
Hi @SaltaSultan
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
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?
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
It works completely fine! Thank you a lot
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
20 | |
19 | |
15 | |
15 |
User | Count |
---|---|
47 | |
28 | |
25 | |
17 | |
17 |