Urgent dax command

[Anonymous]

Hi,

I'm making a dax command to create a flag in a message like "present / no present"  so to do that I use data in column A and B, the two columns come from the same table named: table 1, in column A I have some letters and in column B I have their respective codes, like is shown in the picture below. The measure that I want to do is to create a third column that shows a message "present" if one letter from column A has code as Control and other codes (A1, A5...) from column B; and I would show also "no present" if one letter from column A has only code as Control from column B.             

Thank you! My best regards 

[Nathaniel_C]

Hi @Anonymous ,

So if the count of "X" is 1 in the whole column A, and that row has "Control" in Column B then "Not Present" is returned otherwise "Present" is always returned.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel