cancel
Showing results for
Did you mean:

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a \$100 discount. Register Now

Anonymous
Not applicable

## 1 to 5 score card

I need assistance in creating a measure for a 1- 5 score card based on values calculated below:

``````Ave Defects Identified in HE = AVERAGE('Internal Audit Line Inspection'[% of defects detected at HE])

Score card =
IF (
[Ave Defects Identified in HE] >=90, 5,
IF ([Ave Defects Identified in HE] >=80 && IF ([Ave Defects Identified in HE] <=89, 4,
IF ([Ave Defects Identified in HE] >=70 && IF ([Ave Defects Identified in HE] <=79, 3,
IF ([Ave Defects Identified in HE] >=60 && IF ([Ave Defects Identified in HE] <=69, 2,
IF ([Ave Defects Identified in HE] <=60, 1,
)``````

I'm getting an error as below:

Too many arguments were passed to the IF function. The maximum argument count for the function is 3.

any suggestions as clearly I'm not doing something right.

1 ACCEPTED SOLUTION
Resolver V

HI @Anonymous ,

try below:

Score card = IF ( [Ave Defects Identified in HE] >=90, 5, IF ([Ave Defects Identified in HE] >=80 , 4, IF ([Ave Defects Identified in HE] >=70, 3, IF ([Ave Defects Identified in HE] >=60 ,2,  1 ))))

Regards,

Washivale

3 REPLIES 3
Resolver V

HI @Anonymous ,

try below:

Score card = IF ( [Ave Defects Identified in HE] >=90, 5, IF ([Ave Defects Identified in HE] >=80 , 4, IF ([Ave Defects Identified in HE] >=70, 3, IF ([Ave Defects Identified in HE] >=60 ,2,  1 ))))

Regards,

Washivale

Anonymous
Not applicable

thanks alot. you guys make this seem so simple.

Resolver V

Announcements

#### Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

#### Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

#### Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

#### Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors