Forum Discussion
bcdobbs
Community Champion
Community ChampionArbitrary Shaped Sets
Hi, I've been discussing evaluation contexts particularly with regard to arbitrary shaped sets with Strom on this thread: Evaluation context - mixed filter and row context The original questio...
The description we provide in the book applies to MDX queries and to other scenarios like those obtained using the context transition in a filter context managed by SUMMARIZE and/or ADDCOLUMNS.
Power BI uses a function (SUMMARIZECOLUMNS) that introduces another behavior (could it be called a bug on top of another bug?) which generates results that are less clear and predictable. We never described in detail what happened, because the important thing is that you should use KEEPFILTERS around the table function in the iterator. Or iterate over a single column.
Hi Benjamin,
thank you.
Now I know why Italians love DAX. It's about love and hate and it's a relatively stable relationship 🙂