Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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 'us...
Need Help
Show and Tell
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
5 years ago

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")

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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.