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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Biju
Helper I
Helper I

IF function does not work correctly.

Hi,

 

Please see the attached image,if giving wrong value.Can some one will tell the reason.

 

Capture29jan.PNG

 

A = IF(AND('Training Feedback'[Average Trainer Rating]>=1.0,'Training Feedback'[Average Trainer Rating]<2),"Need Drastic Improvement",IF(AND('Training Feedback'[Average Trainer Rating]>=2.0,'Training Feedback'[Average Trainer Rating]<3),"Need Improvement",IF(AND('Training Feedback'[Average Trainer Rating]>=3.0,'Training Feedback'[Average Trainer Rating]<4),"Good",IF(AND('Training Feedback'[Average Trainer Rating]>=4.0,'Training Feedback'[Average Trainer Rating]<5),"Very Good",IF('Training Feedback'[Average Trainer Rating]=5.0,"Excellent","Need Drastic Improvement")))))

 

4 REPLIES 4
Zubair_Muhammad
Community Champion
Community Champion

@Biju

 

You are duplicating the average trainer rating in the AND clause

 

  AND (
        'Training Feedback'[Average Trainer Rating] >= 1.0,
        'Training Feedback'[Average Trainer Rating] < 2
    ),

 

should be

 

  AND (
        'Training Feedback'[Average Trainer Rating] >= 1.0,
        'Training Feedback'[Total Rating] < 2
    ),


Regards
Zubair

Please try my custom visuals

Hi @Zubair_Muhammad,

 

Thank you for the reply ,but here i dont need to use the column Total Rating.

Hi @Biju

 

OkSmiley Embarassed

 

Check @pawel1 suggestion. Increase the decimal points of the average column

 


Regards
Zubair

Please try my custom visuals
pawel1
Skilled Sharer
Skilled Sharer

that must be rounding issue.  All scores below 5.0 will be 'Very Good', even 4.9999

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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