• SQLBI

  • Home
  • Training
  • Consulting
  • Articles & Blog
  • Videos
  • Books
  • Tools
  • About
  • Menu
  • Search
  • 0
  • LOGIN
  • Home
  • Training
  • Consulting
  • Articles & Blog
  • Videos
  • Books
  • Tools
  • About
LinkedIn Twitter Facebook Email
Marco's blog

How CALCULATE works in DAX

Jan 3, 2010
DAX   Excel   Gemini   Power Pivot  

Marco Russo

Profile   Blog

Blog Archives
  • 2025 (6)
  • 2024 (19)
  • 2023 (11)
  • 2022 (10)
  • 2021 (8)
  • 2020 (11)
  • 2019 (11)
  • 2018 (17)
  • 2017 (25)
  • 2016 (28)
  • 2015 (40)
  • 2014 (59)
  • 2013 (52)
  • 2012 (52)
  • 2011 (89)
  • 2010 (61)
  • 2009 (26)
  • 2008 (44)
  • 2007 (57)
  • 2006 (45)
  • 2005 (36)
  • 2004 (10)
Feed RSS
Oct 1-3, 2025
London
Register
Microsoft doesn’t play the (traditional) BI client game
Microsoft BI Conference 2010 joins TechEd 2010 North America
Aug 26, 2025

Using VALUES in iterators

Why and when you should use VALUES while iterating a table reference in DAX. VALUES When a column name is given, returns a single-column table of unique values. When a table name is given, returns a table with the same…  Read more

Aug 11, 2025

SUMMARIZECOLUMNS best practices

SUMMARIZECOLUMNS is a powerful and complex function in DAX that in 2025 can be used in measures. This article outlines the best practices when using this function to avoid incorrect results. SUMMARIZECOLUMNS Create a summary table for the requested totals…  Read more

Aug 12, 2025

Sideways recursion in DAX calculation groups

This article describes the sideways recursion triggered by invoking a calculation item from another calculation item, explaining why it should be avoided to steer clear of unexpected results.  Read more

Aug 4, 2025

Understanding SUMMARIZECOLUMNS

This advanced paper explains how SUMMARIZECOLUMNS works internally, providing insight into how to control its behavior in queries and measures following a list of best practices. SUMMARIZECOLUMNS Create a summary table for the requested totals over set of groups. SUMMARIZECOLUMNS…  Read more

13:08
Aug 26, 2025

Using VALUES in iterators

Watch now
17:13
Aug 12, 2025

SUMMARIZECOLUMNS best practices

Watch now
39:08
Jul 29, 2025

AI in Power BI: Time to pay attention

Watch now
06:25
Jul 28, 2025

Why we waited so long to talk about AI

Watch now

Comments

Accept cookies to show comments. Cookies Policy
Allow all cookies

Newsletter

 By subscribing you are agreeing to our Privacy Policy.
263.4K subscribers
Get BI news and original content in your inbox every 2 weeks!
Newsletter archive

What is next

  • Mastering DAX – Oct 1
    , London
  • Mastering DAX – Oct 28
    , Lugano
  • Mastering DAX – Nov 4
    , Amsterdam
  • Mastering DAX – Nov 12
    , Chicago
  • Data Modeling for Power BI – Dec 2
    , Amsterdam
  • Mastering DAX – Dec 8
    , Austin
YouTube Twitter LinkedIn Facebook Github RSS Feed
Marco Russo Alberto Ferrari Daniele Perilli
2004-2025 © SQLBI. All rights are reserved.
SQLBI is a trademark of SQLBI Corp.
Loader is a European legal entity.
Privacy Policy & Cookies Terms & Conditions Contact Us
  • SQLBI
  • DAX Guide
  • DAX.do
  • DAX Optimizer
  • DAX Patterns
  • DAX Formatter
  • Bravo for Power BI