In one of our tables we have a measure for Zip Code in the current format "00000-0000". I wanted to create a calculated measure grabbing only the left 5 characters so we can plot them easier on a PowerView Map. I tried creating a calculated field using "=LEFT(Ship-to Customer'[Zip],5)" and i get the following error:
Calculation error in measure 'Ship-to Customer'[5 Digit Zip]: The value for column 'ZIP' in table 'Ship-to Customer' cannot be determined in the current context. Check that all columns referenced in the calculation expression exist, and that there are no circular dependencies. This can also occur when the formula for a measure refers directly to a column without performing any aggregation--such as sum, average, or count--on that column. The column does not have a single value; it has many values, one for each row of the table, and no row has been specified.
How can i create a calculated field to give me only the 5 digit Zip code?
Thanks in advance!
Calculation error in measure 'Ship-to Customer'[5 Digit Zip]: The value for column 'ZIP' in table 'Ship-to Customer' cannot be determined in the current context. Check that all columns referenced in the calculation expression exist, and that there are no circular dependencies. This can also occur when the formula for a measure refers directly to a column without performing any aggregation--such as sum, average, or count--on that column. The column does not have a single value; it has many values, one for each row of the table, and no row has been specified.
How can i create a calculated field to give me only the 5 digit Zip code?
Thanks in advance!
