cancel
Showing results for
Did you mean:

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.

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 Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Power BI Monthly Update - April 2024

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

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors