Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Logic help needed, conditional IF

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 Cus...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    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,

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

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's avatar
Anonymous
Not applicable
7 years ago

Thank you , it works! Much appreciated your help!