Ashley, this one is going to be a tough one to diagnose without a sample packaged workbook, so best to dummy up some data and post a workbook. This is especially true since your color field is a table calculation, so will have different addressing/partitioning on the map (which includes lat/long) than it does on the text table.
Hello Ashley, I replicated calculating a categorical variable from a continuous variable (which seems to be what you are doing) and the new variable was automatically placed among my dimensions. When placed on the color shelf to color circles on a map, multiple colors displayed. Perhaps it's as simple as dragging your calculated variable up to dimensions?
Hey all, thanks for replying. I certainly understand the challenge of helping without the workbook posted. I will work on mastering the art of anonymizing my data for the next round. I was able to get help from Tableau Support as it was a critical issue for a deliverable. Thanks for your willingness to help.
The issue was discovered by dropping DMA Code on the Test worksheet to the Details mark, which broke the color calculation. Blake, from Support, noted that after doing this, I needed to go to Edit Calculation to the Advanced window and Compute by DMA Code and DMA Name. This resolved it on both the Test Worksheet and the map.
Again, thanks for your efforts!