Hey DataFam,
I have always defaulted to using fixed LOD for most of my calculations. Recently I revisited @Bethany Lyons 's post on Top 15 Tableau Expressions and surprisingly realized include LOD and exclude LOD would behave as row level calculations! For instance, I can write the following row level calculation from Superstore and the sum of row-level calc below could return different results based on viz level of detail!
[Sales] - {include:sum([Sales])}I then had an aha moment and realized Tableau actually performs some sort of context transition similar to DAX/PowerBI! Just curious if there are some interesting use cases associated with this? And why the Devs initially decide to let Include and Exclude LOD to behave as row-level calcs?
Thank you!
See the examples in https://jimdehner.com/2022/06/03/just-what-does-include-or-exclude-do/ they will show you some of the use cases - the best way for you to answer your question is for you to do some hands-on experimenting with your own data - see where you would use them
