Forum Discussion

dgilm33's avatar
dgilm33
Icon for Helper I rankHelper I
4 years ago
Solved

UNICHAR showing incorrectly

I have two tables (let's say table A and B). I'm joining on a 1 to many relationship (many being table B and 1 being table A). I'm joining on a unique identifier in both. Table A has unique numbers t...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi dgilm33 ,

     

    I suggest you to try this measure.

    UNICHAR = 
VAR _CATEGORY_B =
    VALUES ( 'Table B'[Category] )
RETURN
    IF ( MAX ( 'Table A'[Category] ) IN _CATEGORY_B, UNICHAR ( 10004 ), BLANK () )

    My Sample:

    Result is as below.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

parry2k's avatar
parry2k
Icon for Super User rankSuper User
4 years ago

dgilm33 what measure you are using to display the checkmark?

 

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

  • dgilm33's avatar
    dgilm33
    Icon for Helper I rankHelper I
    4 years ago

    I have a column (called Conditional Format) in table B that shows 1 if the cross is Direct and 2 if it is similar. Then in the conditional format-Font color I am using Gradient, Values Only, doing a minimum of Conditional format column, formatting empty values as 0, and 1 is green and 2 is yellow.