Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Urgent dax command

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 

 

 

DAX
Dax Help
Measures

1 Reply

  • Nathaniel_C's avatar
    Nathaniel_C
    Community Champion
    6 years ago

    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