article –

Understanding the Application of Calculation Items

This article explains how calculation items are applied to measure references, and it is part of a series dedicated to calculation groups in DAX. Before starting, we suggest you read the previous articles in this series.  Read more

article –

Understanding Calculation Groups

This article explores the properties of calculation groups in detail and then it describes how a calculation item is applied to a measure. Before starting, we suggest you read the previous article that introduces calculation groups.  Read more

We teach DAX and Analysis Services all around the world

More courses
article –

Introducing Calculation Groups

This article is the first of a series dedicated to calculation groups in DAX. This introduction explains the capabilities of this feature and how to create calculation groups in a Tabular model.  Read more

article –

Syncing slicers in Power BI

The June 2019 update of Power BI includes the ability to filter slicer items based on a measure. This article explains why this is an important feature that should replace bidirectional filters used for the same purpose.  Read more

DAX Patterns

ABC Classification – Dynamic

The dynamic version of the ABC Classification pattern is an extension of the Dynamic Segmentation pattern It groups items such as Products or Customers into segments based on their cumulated sales and how much they contributed to the total sales…

Book – Microsoft Press

Analyzing Data with Power BI and Power Pivot for Excel

How can you use Excel and Power BI to gain real insights into your information? As you examine your data, how do you write a formula that provides the numbers you need? The answers to both of these questions lie with the data model. Read more