Forum Discussion
Solved
Understanding Context Transition with Table Filter Arguments
As a follow-up to this post, I've created a simpler example that demonstrates the core of the behavior I still don't quite understand. Consider the following table, 'Data': Data = DATATABLE ...
I believe this is Auto-Exist kicking in. SUMMARIZECOLUMNS combines all filters from the same table into one filter, so in your second evaluation, you have DATA, and DATA[Group] - and they get combined since it is the same table.
Take a look at the detailed explanation of SUMMARIZECOLUMNS() here and then the Auto-Exist issue you may need to contend with here.
Auto-exist is a pain to recon with.
can this help you?
think you can get more from here
https://www.sqlbi.com/articles/all-the-secrets-of-summarize/