Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Returning a different value based on duplicates

Hello, all...I am thankful you exist. 🙂   Here is my issue:   I am trying to do a pie chart that compares number of arrests where a mental health flag is present vs. when it is not.   I have d...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi Anonymous 

    Please try

    MH Flag =
    IF (
    "MH"
    IN CALCULATETABLE (
    VALUES ( 'Table'[Flag] ),
    ALLEXCEPT ( 'Table', 'Table'[Asset #] )
    ),
    IF ( 'Table'[Flag] = "MH", "Yes" ),
    "No"
    )

Anonymous's avatar
Anonymous
Not applicable
3 years ago

tamerj1,

 

You are a genius beyond measure. It worked. Thank you so much!!

 

Crystal