Forum Discussion
Solved
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 beginni...
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
amitchandak
Super User
Super UserFredChew , 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
)
)