Forum Discussion

Maverick_BI's avatar
Maverick_BI
New Member
3 years ago

If Statement Working With Two Seperate Database Tables

Hello Everyone,   I have an request that has been causing me some trouble on how to resolve.   I have a need for a new column to be created which uses an If or Case statement where possible.   ...
Need Help
rajulshah's avatar
rajulshah
Resident Rockstar
3 years ago

Maverick_BI 

You can use the following DAX function:

$Column Customer Ordered = IF(
'SYSADM ORDER'[AH_IDENT] = 'SYSADM CUSTOMER'[ID] && 
'SYSADM CUSTOMER'[ID] <> "0" ||
NOT 'SYSADM CUSTOMER'[LOCKED] IN "1","3"
,"Order","No Order"
)

Let me know if this didn't help.

Maverick_BI's avatar
Maverick_BI
New Member
3 years ago

Hello rajulshah,

Thank you for the quick response unfortunately the same message appeared as what I am trying to resolve as shown below.

 

  • rajulshah's avatar
    rajulshah
    Resident Rockstar
    3 years ago

    Maverick_BI Are you creating a new measure or new column?

    • Maverick_BI's avatar
      Maverick_BI
      New Member
      3 years ago

      rajulshahI was originally attempting to do this as a new column, however if I need to do it as a measure then I have no concerns in doing it this way.

      • rajulshah's avatar
        rajulshah
        Resident Rockstar
        3 years ago

        Maverick_BI , If you are creating a calculated measure, then you need to use an aggregated value for columns, for instance, you can use SELECTEDVALUE.

        $Column Customer Ordered = IF(
SELECTEDVALUE('SYSADM ORDER'[AH_IDENT]) = 'SYSADM CUSTOMER'[ID] && 
SELECTEDVALUE('SYSADM CUSTOMER'[ID]) <> "0" ||
NOT SELECTEDVALUE('SYSADM CUSTOMER'[LOCKED]) IN {"1","3"}
,"Order","No Order"
)

         

        Please let me know if this didn't work.