• 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
Aug 19-21, 2025
Toronto
Register
Microsoft doesn’t play the (traditional) BI client game
Microsoft BI Conference 2010 joins TechEd 2010 North America
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

Jul 28, 2025

AI in Power BI: Time to pay attention

This article is about the state of AI tools with Power BI, and how to use the model context protocol (or MCP) to interact with and control Power BI or Fabric with a large language model (or LLM).  Read more

Jul 14, 2025

ALLSELECTED best practices

ALLSELECTED is a powerful, yet dangerous function. This article describes the best practices to follow to avoid falling into the pitfalls involved with ALLSELECTED. ALLSELECTED CALCULATE modifier Returns all the rows in a table, or all the values in a…  Read more

Jun 30, 2025

Choosing between DISTINCT and VALUES in DAX

When should you use DISTINCT over VALUES in DAX? Here is how to write resilient measures that survive bad data and model changes. DISTINCT Returns a one column table that contains the distinct (unique) values in a column, for a…  Read more

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
21:43
Jul 15, 2025

ALLSELECTED best practices

Watch now
18:09
Jul 1, 2025

Choosing between DISTINCT and VALUES in DAX

Watch now

Comments

Accept cookies to show comments. Cookies Policy
Allow all cookies

Newsletter

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

What is next

  • Mastering DAX – Aug 19
    , Toronto
  • 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