• 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
Jun 1, 2026

ALL vs ALLSELECTED vs ALLEXCEPT vs REMOVEFILTERS

DAX offers many functions to remove filters from the filter context. In this article, we analyze the differences among the most commonly-used functions.  Read more

May 18, 2026

Introducing user-aware calculated columns in Power BI

This article describes the new Expression Context property of calculated columns in Power BI, explaining how user-aware calculated columns work, why they are not materialized, and how to use them as virtual calculated columns for localization and custom security scenarios.  Read more

May 4, 2026

Filtering measures through slicers

A slicer cannot filter a measure. In this article, we analyze this common request by explaining how to use a slicer to filter a measure, after discussing the real meaning of using a measure with a slicer.  Read more

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

18:45
Jun 2, 2026

ALL vs ALLSELECTED vs ALLEXCEPT vs REMOVEFILTERS

Watch now
26:10
May 19, 2026

Introducing user-aware calculated columns in Power BI

Watch now
11:45
May 5, 2026

Filtering measures through slicers

Watch now
27:47
Apr 21, 2026

Parameter types in DAX user defined functions UDF

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.8K subscribers
Get BI news and original content in your inbox every 2 weeks!
Newsletter archive

What is next

  • Mastering DAX – Jun 10
    , Zürich
  • Mastering DAX – Jun 15
    , Berlin
  • Mastering DAX – Jun 30
    , Amsterdam
  • Data Modeling for Power BI – Jul 21
    , Amsterdam
  • Mastering DAX – Oct 27
    , Lugano
  • Mastering DAX – Nov 9
    , Atlanta
  • Mastering DAX – Nov 24
    , London
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