DAX

Understanding the difference between row context and filter context is the first and most important concept to learn to use DAX correctly. This article introduces the row context, and is part of a series of articles about evaluation contexts in DAX. Most newbies start writing DAX code by creating sim

This article is part of a series of articles about the basics of DAX. In a previous article, we introduced the first evaluation context in DAX: the row context. If you are not familiar with the row …

This post shows how to Show measures in tabular format with calculation groups. Getting format strings right is the trickiest part, and we find some limitations

Overriding calculation items in tooltips is not straight forward, but using calculation groups inside measures is a convenient workaround

Making sure that you do not have referential integrity problems is not easy. The Script for Referential Integrity Check Measures will automate most of the work.

This article describes how to return BLANK instead of zero in a DAX measure. Using this technique, you can remove rows in a Power BI matrix visual where the

Showing Measure Description in tooltip is not straight forward. With DMV and a couple of calculation groups is possible to achieve it.

How many ways there are to create a Year-Month column in DAX? In this blog post, I'll show you one bad way, one OK way, one good, and one great way.

This article describes the IN operator in DAX, which simplifies logical conditions checking whether a certain value belongs to a list of values. The IN oper

Here is how to calculate weighted average using DAX in Power BI. By using that, you can get results by necessary category.

One of the questions that I’ve been asked consistently over the past...

Few ways to get relative & abolsute refresh durations in Power BI

This post explains how to build a multiple measure selector in chart, so that only part of the measures are displayed. A calculation group makes it possible.

The concept of extended tables is at the core of the query performance of Power BI datasets, but it is often overlooked. This article will hopefully change this.

A step by step guide to implement the Poisson Distribution in Power BI using DAX

In this post, I will describe what is the Pearson correlation coefficient and how to implement it in Power BI using DAX. What is Correlation Coefficient The correlation coefficient is a statistical measure of the relationship between two variables; the values range between -1 and 1. A correlation of -1 shows a perfect negative correlation, a correlation of 1 shows a perfect positive correlation. A correlation of 0.0 shows no linear relationship between the movement of the two variables. How to interpret...p class="read-more"a class="btn btn-default" href="https://datakuity.com/2021/10/29/correlation-coefficient-in-power-bi-using-dax/" Read Morespan class="screen-reader-text" Read More/span/a/p

List of the most comon Univariate Statistics DAX Cheatsheet available in Power BI with their DAX code

A step by step guide to implement a paired t-test in Power BI using DAX only

OR logic in DAX is frequently used in various Power BI calculations. The bad and the good news is that you can create that in multiple ways.

Do you think Microsoft's files always follow best practices? In this episode, I'm dissecting a DAX formula from an automatically generated Power BI file.

This article provides the best practice to use ADDCOLUMNS and SUMMARIZE, two functions that can be used in any DAX expression, including measures. UPDATE 20

There are some calculation groups that you might use in almost any project you do. Here you'll find C# Scripts to create calculation groups that you should have

En anteriores posts vimos diferentes cálculos en DAX como por ejemplo conocer cuántos clientes habían efectuado su última compra hace 90 días, este cálculo permitía llegar a cierta segmentación de...

This article explains how to correctly measure the dictionary size of a column in a model created in Power BI, Power Pivot, or Analysis Services Tabular. When you use VertiPaq Analyzer or the data management view (DMV) to get the size of the dictionary of a column (DISCOVER_STORAGE_TABLE_COLUMNS), yo

This article introduces the syntax to describe in a textual form the DAX expressions and additional properties of calculation groups. When calculation group

Our Power BI Principal Consultant Kane Snyder shares a technique for optimising calculation group performance.

Using ALLSELECTED with no arguments in a remote model later used in a composite model might produce unexpected results. In this article we examine the topic