dax

SUMMARIZE is a very powerful and very complex function to use. This article describes its internal behavior, and provides guidance on how to use it. If you like to follow best practices, you can just read this paragraph out of the entire article. If you are using SUMMARIZE to calculate new columns, s

Learn how to get a field's value from another table in Power BI using the Related function in DAX and traversing through the existing relationship

SUMMARIZE is a very powerful and very complex function to use. This article describes its internal behavior, and provides guidance on how to use it. If you

Evaluation context is the most important concept to understand in DAX . This context is used when evaluating expressions to get to the result.

Power BI Calculation groups can solve data modeling challenges in a clean easy way, like a table filtering two dimension tables without model relationships

Learn how to use the RELATEDTABLE function in DAX and Power BI to get a subset of rows from a related table

Power BI has the built-in feature of creating binning for a numeric field such as age. However, the default binning will create bins of equal size. If you want to create bins of different sizes, then …

Time to read: 4 minutes Calculation groups is a powerful feature in Power BI. However, using them adds some complexity and brings some limitations to Power BI’s native functionality. Or... Read more »

Dev Consultant Jean Hayes spotlights Data Analysis Expressions (DAX) with Calculation Groups. Power BI Premium (Preview), Azure Analysis Services and SQL Server Analysis Services 2019 now support Calculation Groups! Why am I so excited? Because this functionality was one of the best capabilities in Multidimensional Analysis Services through Named Sets and Calculated Members.

Calculation groups can apply specific calculations onto existing DAX measures. For example, calculation groups can implement time intelligence calculations

C# scripts are great to automate tasks which are repetitive but have some customization for each model

Calculated tables are not used often, because after all, it only combines data that you already have, right? Well, I didn't use them often, until recently...

Explore how to create custom groups based on a slicer selection in Power BI. For example, create two versions of a measure: one returns the value of the sel

Learn how to push your report level measures into your tabular model!

ADDCOLUMNS: Returns a table with new columns specified by the DAX expressions. https://dax.guide/addcolumns/

In this article we show some techniques to force a measure to return zero instead of blank, in order to highlight combinations of attributes with no data. P

In a previous story, I explained some details about Semi-Additive Measures. Here are some more hints on this topic

A client had a problem with his report. I was asked to find the issue and solve it. This is the story about it

In this tutorial, I’d like to discuss how you can improve your creativity when creating custom visual reports in Power BI. I highly recommend creating projects that are outside your organization’s environment. This is because when creating projects for your organization, your creativity is limited. M

DAX is simple, but it is not easy. I cannot remember how many times I read this sentence on social media, attributed to me. For good reason: I have repeated

This article provides a complete explanation of the behavior of the ALLxxx functions in DAX. When used as filters in CALCULATE, ALLxxx functions might displ

Bottom N Analysis in Power BI

I was helping someone recently with an issue. They wanted to allow end users (department managers in this case) to enter data in a table as simply as possible, and then use this data for reporting. The challenge often is, that the easiest way to enter data from a user’s [...]Read More »

DAX Studio 2.16 has two new preview features: Show Debug Commas and Show XMLA Commands. With Show Debug Commas you enable a button to move commas from the e

This article describes how blank values considered in a DAX conditional expression can affect its query plan and how to apply possible optimizations to impr

Learn how to change the direction of a relationship within a Power BI measure using DAX expression with CrossFilter function

This tutorial will discuss about materialization for data caches in DAX Studio. This post will show how it affects your calculation while generating results with your query. You’ll learn which materialization is better in order to maximize DAX’s performance.There are two ideas of materialization: Ear

In this tutorial, you’ll learn about what data caches do in a DAX calculation. You’ll understand how they work with the formula and storage engines to provide answers to your queries.Download Free Resources HereWhat Are Data Caches?The storage engine interacts with the formula engine in the form of a

This blog post is following on my previous posts using community tools to improve your data model. Previously we used Tabular Editor: here and here. Now let’s define what RI (referential integrity) …