Auto-exist on clusters or numbers – Unplugged #22

Enter the complexities of auto-exist in SUMMARIZECOLUMNS, which returns different results depending on how the filters are applied to the filter context. Same formula, same model, but different results using different DAX queries that apparently should provide the same results.
A long lesson about auto-exist for those who want to know how it works and not just how to use it.