• 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
  • 2026 (4)
  • 2025 (8)
  • 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
Microsoft doesn’t play the (traditional) BI client game
Microsoft BI Conference 2010 joins TechEd 2010 North America
Apr 21, 2026

Understanding parameter types in DAX user-defined functions (UDF)

This article describes the parameter types available in DAX user-defined functions, focusing on the specialized reference types MEASUREREF, COLUMNREF, TABLEREF, and CALENDARREF.  Read more

Apr 6, 2026

Using visual calculations to highlight an entire row

Visual calculations can be used efficiently to format visuals. This article presents an interesting technique to highlight a row based solely on the maximum value in the last column.  Read more

Apr 1, 2026

The Third Edition of the Mastering DAX Video Course – unplugged

Alberto and I recorded an unplugged session to talk about the new edition of the Mastering DAX Video Course. You can watch it above, but if you prefer a quick read, here are some thoughts. The question we heard the…  Read more

Mar 25, 2026

DAX user-defined functions (UDF) vs. calculation groups

This article describes the different roles of user-defined functions and calculation groups, explaining when to use either, and how they complement each other in the design of a semantic model.  Read more

27:47
Apr 21, 2026

Parameter types in DAX user defined functions UDF

Watch now
21:14
Apr 7, 2026

Using visual calculation to highlight an entire row

Watch now
14:26
Apr 1, 2026

Mastering DAX 3rd Edition Unplugged

Watch now
24:32
Mar 26, 2026

DAX User-Defined Functions vs Calculation Groups

Watch now

Comments

Accept cookies to show comments. Cookies Policy
Allow all cookies

Newsletter

By subscribing, you agree to our Privacy Policy. This site is protected by reCAPTCHA.
276.0K subscribers
Get BI news and original content in your inbox every 2 weeks!
Newsletter archive

What is next

  • Mastering DAX – May 5
    , Copenhagen
  • Mastering DAX – May 27
    , Baltimore
  • Mastering DAX – Jun 10
    , Zürich
  • Mastering DAX – Jun 15
    , Berlin
  • Mastering DAX – Jun 30
    , Amsterdam
  • Data Modeling for Power BI – Jul 21
    , Amsterdam
YouTube Twitter LinkedIn Facebook Github RSS Feed
Marco Russo Alberto Ferrari Daniele Perilli
2004-2026 © 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 Patterns
  • DAX Lib
  • DAX.do
  • DAX Formatter
  • DAX Optimizer
  • Bravo for Power BI