Forum Discussion
Error with alpha numeric comparsion
Hi there,
I am trying to compare a column with email address (as table) that starts with an alphabet eg [email protected] , but it doesn't seems to work. But when I removed the u in the beginning on both the record and the script i was able to get a return of '1'. why is that so?
| CourseCode | user |
| ENVS1001 | [email protected] |
| ENVS1003 | [email protected] |
| ENVS1004 | [email protected] |
| ENVS1008 | [email protected] |
| ENVS2001 | [email protected] |
| ENVS2002 | [email protected] |
Hi FredChew ,
Your measure works well based on my test, there may be something wrong with your raw data. You can also try :
Measure = IF(EXACT("[email protected]",MAX(Courses_and_Teachers[user])),1,0)If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
2 Replies
FredChew , based on what I got, check if that is u or some special character
also try
Measure =
CALCULATE (
IF (
search("[email protected]", MIN ('Courses_and_Teachers'[user]),,0)
>0 ,
1,
0
)
)Hi FredChew ,
Your measure works well based on my test, there may be something wrong with your raw data. You can also try :
Measure = IF(EXACT("[email protected]",MAX(Courses_and_Teachers[user])),1,0)If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
