• 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

ABC Analysis in PowerPivot

Jan 19, 2010
DAX   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
Memory Considerations about PowerPivot for Excel
PASS Summit 2009 Evaluations
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

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

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
21:14
Apr 7, 2026

Using visual calculation to highlight an entire row

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

What is next

  • 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
  • Mastering DAX – Oct 27
    , Lugano
  • Mastering DAX – Nov 9
    , Atlanta
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