dax

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 »

Calculation groups are one of the most powerful features to reduce the data model complexity and measure redundancy!

Join Bernat Agulló and I as he shows you how to level up your skills in Tabular Editor ! He'll spend time showing you how to use C# scripts and macros to create calculation groups , diagnose and optimize your model , and much more! Plus learn how to leverage Visual Studio to cr

We recently discussed an issue related to the Dictionary size reported by Bravo for Power BI that, in reality, references the behavior of VertiPaq Analyzer,

Scenario: We usually hear words like words context, filter context when creating measure. Moreover, we can often see it on the DAX Guide website. But what is that? And how can we modify it? What is filter context? The reason why we sometimes cannot get the ideal result when we use a measure with sa...

In this article, we will discuss how to deal with some common problems when creating reports based on employee attendance sheets. Next, let's take a closer look at the below scenarios. Scenario 1: Clean and extract valid records from attendance sheets Invalid or repeated employee punching behavior ...

I had a business requirement where I needed to create a P&L report that included RLS by business leaders for each department. A leader…

It is not common to face rounding differences in Power BI. However, when it happens, users are usually disappointed and surprised. In one of the last classr

In the 2nd part of "Brain & Muscles" behind Power BI series, learn about data compression and how VertiPaq chooses the right algorithm to make your data model optimal

Have you ever wondered what makes Power BI so fast and powerful when it comes to performance? In the 1st part of the series, meet VertiPaq - "brain & muscles" behind Power BI!