Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!View all the Fabric Data Days sessions on demand. View schedule
Hi All,
Getting error as - "Argument '18' in SWITCH function is required"
case1 = SWITCH(TRUE(),
Metrics[Methodology-project_type] = "Agile",
(SWITCH(TRUE(),Metrics[MyWizard_Metric_Name] = "Sprint" &&
(isblank([MetdefAgile_Sprint_Velocity_Ratio_Agile--overall&auto])||[MetdefAgile_Sprint_Velocity_Ratio_Agile--overall&auto]= "")
&&[MyWizard_Metric_Value]>=0 && ISBLANK([N/A]) && Metrics[Agile-cond] in{"All","One"} &&
Metrics[MyWizard_Metric_Value]<> BLANK(),1,
--
Metrics[MyWizard_Metric_Name] = "Rework" && ([MetdefAgile_Cost_of_Rework_Agile-overall&auto] = blank() ||
[MetdefAgile_Cost_of_Rework_Agile-overall&auto] = "")&&
[MyWizard_Metric_Value]>=0 && ISBLANK([N/A]) && Metrics[Agile-cond] in{"All","Top4"} && [MyWizard_Metric_Value]= blank(),1,
--
Metrics[MyWizard_Metric_Name] = "Overall" && ([MetdefAgile_Overall_Defect_Rate-overall&auto] = blank()||
[MetdefAgile_Overall_Defect_Rate-overall&auto] = "") && [MyWizard_Metric_Value]>=0 &&
ISBLANK([N/A]) && Metrics[Agile-cond] = "All" && [MyWizard_Metric_Value]= blank(),1,
--
Metrics[MyWizard_Metric_Name] = "Automation" &&([MetdefAgile_Test_Automation_Penetration-overall&auto] = blank() ||
[MetdefAgile_Test_Automation_Penetration-overall&auto] = "") &&
[MyWizard_Metric_Value]>=0 && ISBLANK([N/A]) && Metrics[Agile-cond] in{"All","Top4"}
&& [MyWizard_Metric_Value]= blank(),1,
--
Metrics[MyWizard_Metric_Name] = "Testing" && ([MetdefAgile_Testing_Effectiveness_Agile-overall&auto] = blank()
||[MetdefAgile_Testing_Effectiveness_Agile-overall&auto] = "") && [MyWizard_Metric_Value]>=0 &&
ISBLANK([N/A]) && Metrics[Agile-cond] ="All" && [MyWizard_Metric_Value]= blank(),1,
--
Metrics[MyWizard_Metric_Name] = "Test",([MetdefAgile_Test_Case_Pass_Trend_Agile-overall&auto] = blank()
||[MetdefAgile_Test_Case_Pass_Trend_Agile-overall&auto] = "") && [MyWizard_Metric_Value]>=0 && ISBLANK([N/A])
&& Metrics[Agile-cond] = "All" && [MyWizard_Metric_Value]= blank(),1,
--
Metrics[MyWizard_Metric_Name] = "Test1",([MetdefAgile_Test_Artifact_Execution_Trend_Agile-overall&auto]= blank()
||[MetdefAgile_Test_Artifact_Execution_Trend_Agile-overall&auto] = "") && [MyWizard_Metric_Value]>=0 && ISBLANK([N/A])
&& Metrics[Agile-cond] = "All" && [MyWizard_Metric_Value]= blank(),1,)),
)
please suggest on this error, how to fix
@Anonymous , Try like
SWITCH(TRUE(),
Metrics[Methodology-project_type] = "Agile",
SWITCH(TRUE(),Metrics[MyWizard_Metric_Name] = "Sprint" &&
isblank([MetdefAgile_Sprint_Velocity_Ratio_Agile])||[MetdefAgile_Sprint_Velocity_Ratio_Agile--overall&auto]= "")
&&[MyWizard_Metric_Value]>=0 && ISBLANK([N/A]) && Metrics[Agile-cond] in{"All","One"} &&
Metrics[MyWizard_Metric_Value]<> BLANK(),1,
--
Metrics[MyWizard_Metric_Name] = "Rework" && ([MetdefAgile_Cost_of_Rework_Agile-overall&auto] = blank() ||
[MetdefAgile_Cost_of_Rework_Agile-overall&auto] = "")&&
[MyWizard_Metric_Value]>=0 && ISBLANK([N/A]) && Metrics[Agile-cond] in{"All","Top4"} && [MyWizard_Metric_Value]= blank(),1,
--
Metrics[MyWizard_Metric_Name] = "Overall" && ([MetdefAgile_Overall_Defect_Rate-overall&auto] = blank()||
[MetdefAgile_Overall_Defect_Rate-overall&auto] = "") && [MyWizard_Metric_Value]>=0 &&
ISBLANK([N/A]) && Metrics[Agile-cond] = "All" && [MyWizard_Metric_Value]= blank(),1,
--
Metrics[MyWizard_Metric_Name] = "Automation" &&([MetdefAgile_Test_Automation_Penetration-overall&auto] = blank() ||
[MetdefAgile_Test_Automation_Penetration-overall&auto] = "") &&
[MyWizard_Metric_Value]>=0 && ISBLANK([N/A]) && Metrics[Agile-cond] in{"All","Top4"}
&& [MyWizard_Metric_Value]= blank(),1,
--
Metrics[MyWizard_Metric_Name] = "Testing" && ([MetdefAgile_Testing_Effectiveness_Agile-overall&auto] = blank()
||[MetdefAgile_Testing_Effectiveness_Agile-overall&auto] = "") && [MyWizard_Metric_Value]>=0 &&
ISBLANK([N/A]) && Metrics[Agile-cond] ="All" && [MyWizard_Metric_Value]= blank(),1,
--
Metrics[MyWizard_Metric_Name] = "Test",([MetdefAgile_Test_Case_Pass_Trend_Agile-overall&auto] = blank()
||[MetdefAgile_Test_Case_Pass_Trend_Agile-overall&auto] = "") && [MyWizard_Metric_Value]>=0 && ISBLANK([N/A])
&& Metrics[Agile-cond] = "All" && [MyWizard_Metric_Value]= blank(),1,
--
Metrics[MyWizard_Metric_Name] = "Test1",([MetdefAgile_Test_Artifact_Execution_Trend_Agile-overall&auto]= blank()
||[MetdefAgile_Test_Artifact_Execution_Trend_Agile-overall&auto] = "") && [MyWizard_Metric_Value]>=0 && ISBLANK([N/A])
&& Metrics[Agile-cond] = "All" && [MyWizard_Metric_Value]= blank(),1
) )
But might need sample file to test
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!