1 of 1 people found this helpful
Nested calculations result in multiple queries for each new IF. It's much better to do a single IF or a single CASE with multiple conditions. I had to do a bunch of string comparisons and kept hitting unacceptable performance issues using nested IFs. Once I swapped to a bunch of ELSEIFs, the performace was improved immensely.
Edit: Check out this whitepaper: Best Practices For Designing Efficient Tableau Workbooks