Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How do you create a Conditional Column from 2 tables ?

I need to compare email addresses.   If Table "serial" (email address) is different from Table "Monthly Billing" (email address), display Yes If Table "serial" (email address) is the same as Table...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    5 years ago

    RESOLVED:

     

    Mismatch = if(MAXX(FILTER('Monthly Billing','Monthly Billing'[Tangoe Owner Email]='users'[Intune Owner Email]),'Monthly Billing'[Tangoe Owner Email])=users[Intune Owner Email],"NO","Yes")

ryan_mayu's avatar
ryan_mayu
Super User
5 years ago

Anonymous 

you can try to create a column

Column = if(MAXX(FILTER('Monthly Billing','Monthly Billing'[email address]=serial[email address]),'Monthly Billing'[email address])=serial[email address],"No","Yes")
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    The following DAX expression appears when creating column...

    A single value for column 'Intune Owner Email' in table 'users' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.

     

    Please advise.

     

     

     

     

     

    • ryan_mayu's avatar
      ryan_mayu
      Super User
      5 years ago

      Anonymous 

      are you creating a measure?

      could you pls provide some sample data?

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Intune Owner Email is from the users table.

        Tangoe Owner Email wis from the Monthly Billing table.

        I need a column or measure that compares the 2 columns and displays mismatches in a separate column on my dashboard.

         

         

        When I apply the following as a calculated column:

        Mismatch = if(MAXX(FILTER('Monthly Billing','Monthly Billing'[Tangoe Owner Email]=users[Intune Owner Email]),'Monthly Billing'[Tangoe Owner Email])=users[Intune Owner Email],"No","Yes")

         

        I get the following error:

         

        A single value for column 'Intune Owner Email' in table 'users' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.