The same measure returns 5,060 on every product row and a different number on every region row. Why CALCULATE replaces one filter and adds the other, and how KEEPFILTERS changes it.
Michael Nocito
Data analyst, eight years of enterprise data migration. I write step by step guides for analyst work and build browser practice kits for SQL, Excel, Python, Power BI and Tableau.
Location
Glassboro, New Jersey
Work
One formula, many cells. FILTER, UNIQUE, SORT and SORTBY worked on a real table, the spill reference, what #SPILL! and #CALC!…
If you’ve ever struggled with CALCULATE() or wondered why SUMX() behaves differently from SUM(), this...
SUM takes one column. SUMX takes a table and an expression and evaluates it on every row before adding up. Worked on sixteen…
How a single SQL filter applied to a Bronto dashboard instantly updates every widget — turning a complex multi-step data lookup…
A practical guide to user-aware calculated columns in Power BI, using Expression Context, USERCULTURE, virtual columns, and…
In most embedded analytics, the only thing standing between two customers' data is a WHERE...
