Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
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
Washivale
Resolver V
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

View solution in original post

3 REPLIES 3
Washivale
Resolver V
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. 

glad that helped!!

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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