Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
Please see the attached image,if giving wrong value.Can some one will tell the reason.
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")))))
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
),
that must be rounding issue. All scores below 5.0 will be 'Very Good', even 4.9999
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |