The join seems to be working as I would expect. I've reattached the workbook with a new sheet (Sheet 3) and the field members are there. Am I missing something?
KPI_101MIN.twbx.zip 951.8 KB
You know- it was an artifact of me trying to hide "null" or "NA" from the color/performance legend.
It actually filtered all the values out that had "NA" associated with them.
I have two types of "NA"s in the full version of the spreadsheet/viz (not attached): One was an actual "NA", the other appears to be the result of Tableau's dealing with aggregated fields with different values summing up to a parent field.
So I removed all NA from my spreadsheet, but now it's coming up with "Null" values.
http://kb.tableausoftware.com/articles/knowledgebase/null-values says to right click on the axis to remove the values, but I don't see how to do that with this table.