Forum Discussion
Error: A single value for column in table cannot be determined
I have 2 columns I need to compare.
They are from 2 separate tables.
Trying to display a mismatch.
However 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.
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")
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..sample below.
Intune Owner Email Tangoe Owner Email
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.
2 Replies
Anonymous Without sample data and relationships, hard to be certain but that DAX looks way off. Perhaps you mean something like the following:
Mismatch = IF( 'Monthly Billing'[Tangoe Owner Email]=RELATED(users[Intune Owner Email]),"No","Yes")As a Calculated Column and as a Measure,the same error appears:
A single value for column 'Tangoe Owner Email' in table 'Monthly Billing' 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.
