Power pivot - calculated field

[jakobt]

Have a power pivot with two tables named Data and Accounts list 2019 and a relationship between the two tables on the column "account".

I try to create a calculated field between the field sum of yeartotal in table data and signage in table accounts list 2019.

The field has the formula:
=Data[Sum of YearTotal]*'Accounts List 2019'[Signage]

I receive the following error:
could not add the field measure1 because the formula is invalid
a single value for column signage in table accounts list 2019 cannot be determined.

 

[peter789]

Think you need to re-plan your schema. Sounds like you are trying to join two fact tables. Account should probably exist as a dimension table, linked to the two fact tables.
Alternately go for the "big fat" approach and merge the two tables in Power query.