Logic help needed, conditional IF

[Anonymous]

Hello all gurus, I am new to PowerBI and need some help! 

I have a database like below: 

I need some help to figure out a DAX for this logic: if a customer_id was identified as an "NSU Customer", then that customer_id is a customer regardless of their charge_plan. 

So eventually I want to get to a table like this: 

Appreciated any advice, 

[v-jiascu-msft · Accepted solution]

Hi @Anonymous ,

Try this one as a measure, please.

Measure =
IF (
    "NSU Customer"
        IN CALCULATETABLE (
            VALUES ( 'table1'[NSU plan group] ),
            ALLEXCEPT ( 'table1', 'table1'[customer_id] )
        ),
    "Customer",
    "Not Customer"
)

Best Regards,

[Anonymous]

Thank you v-jiascu-msft, it works! Much appreciated your help!