2 of 2 people found this helpful
So looks like you've done a switch datasource?...
So this is a bit annoying, but when Tableau does a "Replace datasource" it does it imperfectly!
One of the things that goes wrong is "dependent" calcs don't get written across. These are calcs that are used in other calcs, but are never used (themselves) is any sheet. If I look in your error-ed calc, I see this
Just a reference to a calc it can no longer find....So one solution is to keep a sheet where you drop every calc (filter it to 1 day, or a tiny amount of data...it only needs to be present)
Or what I did was look at that calc in the original...
So could see it was the [Count in District] that was missing. I just copied this from the original to the new datasource (you can just right click a dim or measure, select copy and then paste into new datasource. As it retains it's original name (the [Calculation_2134322.....] the [1st Or 2nd Place] field picked it up and now works again.
Hope that helps and makes sense
also you may want to vote this idea up https://community.tableau.com/ideas/5655 I'd also recommend reading the thread comments as there is lots of good links to "workarounds" that help make it a bit less annoying (there is also a fair bit of frustration in some of the comments too!!)
Thank you so much! Interestingly enough...it wasn't giving me all the calculated function abilities until I saved and then reopened the workbook just now.