• 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
May 20-22, 2025
Amsterdam
Register
Microsoft doesn’t play the (traditional) BI client game
Microsoft BI Conference 2010 joins TechEd 2010 North America
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

Apr 21, 2025

Dynamic Pareto analysis in Power BI

This article describes how to implement a dynamic Pareto calculation in Power BI based on a measure that can be selected from a slicer and dynamically filtered by other slicers in the report.  Read more

Apr 8, 2025

Filtering weekdays in DAX

When using time intelligence functions, the automatic REMOVEFILTERS on Date can make maintaining filters on the Date table challenging. This article shows a technique to handle filter-preserving columns in DAX. REMOVEFILTERS CALCULATE modifier Clear filters from the specified tables or…  Read more

Apr 7, 2025

DAX and semantic models announcements at the Fabric Conference 2025

I usually do not write about announcements and new features until we have had time to try and test them in the real world. However, there are always exceptions, and some of the announcements at the Microsoft Fabric Conference 2025…  Read more

01:34:32
May 13, 2025

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

Watch now
45:55
May 6, 2025

Tools in Power BI

Watch now
04:52
May 2, 2025

DAX Optimizer 1.4 news

Watch now
31:07
Apr 22, 2025

Dynamic Pareto analysis in Power BI

Watch now

Comments

Accept cookies to show comments. Cookies Policy
Allow all cookies

Newsletter

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

What is next

  • Mastering DAX – May 20
    , Amsterdam
  • Mastering DAX – May 28
    , Chicago
  • Data Modeling for Power BI – Jun 24
    , Amsterdam
  • Mastering DAX – Jul 9
    , Seattle
  • Mastering DAX – Aug 19
    , Toronto
  • Mastering DAX – Oct 1
    , London
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