Power BI

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

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

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

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

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...

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

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.

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.

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

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

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

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

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.

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.

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

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

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

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

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.

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

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

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.

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

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

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 …

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

What?! Exploding Measures I hear you say. Exploding, expanding, use which ever word you like; what I mean is when you want to remove any refence to a measure INSIDE another measure. Example Consider the 3 measures below. Total Sales = SUM(Sales[ExtendedAmount]) Total All Product Sales = CALCULATE([Total Sales],ALL(Products)) % [...]Read More »