• 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 (4)
  • 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
Jul 9-11, 2025
Seattle
Register
Microsoft doesn’t play the (traditional) BI client game
Microsoft BI Conference 2010 joins TechEd 2010 North America
Jun 17, 2025

Understanding how DAX evaluates IF statements

In this article, we examine the details of executing DAX code, with a focus on how the IF function is implemented in various scenarios. IF Checks whether a condition is met, and returns one value if TRUE, and another value…  Read more

Jun 2, 2025

Controlling empty or multiple selections in calculation groups

This article describes how to control the execution of DAX code when there are either multiple or empty selections of calculation items in calculation groups.  Read more

May 19, 2025

Understanding the “can’t determine relationship between the fields” error in Power BI

This article explains why you might encounter a curious error when placing columns from unrelated tables in a Power BI matrix.  Read more

Apr 28, 2025

Security in Tabular Semantic Models

How to implement security in Tabular semantic models considering different requirements, data model design, DAX implementation, and performance.  Read more

11:39
Jun 17, 2025

Understanding how DAX evaluates IF statements

Watch now
36:41
Jun 3, 2025

Controlling empty or multiple selection in calculation groups

Watch now
20:16
May 20, 2025

Understanding the cannot determine relationship between the fields error in Power BI

Watch now
01:34:32
May 13, 2025

Direct Lake vs Import vs Direct Lake+Import | Fabric semantic models (May 2025)

Watch now

Comments

Accept cookies to show comments. Cookies Policy
Allow all cookies

Newsletter

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

What is next

  • Mastering DAX – Jul 9
    , Seattle
  • 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
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