DAX

Finding the main bottleneck in your Power BI report may be a challenging task. Learn how to quickly identify the poor performing report elements and how to improve the overall performance by applying some clever tricks!

Power BI’s DAX language is often described as “simple but not easy.” While visuals such as tables and matrices generate a lot of DAX behind the scenes, such as subtotals and total…

Using a script to create measures from a calculation group with correct format, for use cases where a base measure and a calculation group filter will not work.

Background I recently shared on Twitter a 7-module learning path on MS Learn that teaches all you need to know about calculation groups in Power BI. This learning path is an excellent course, and I highly recommend it. However, as part of this exchange, I received a reply from someone lamenting that calculation groups are … Continue reading Using PowerShell to create Calculation Groups in Power BI Desktop

In May 2022 Desktop update, we recieved the Field parameters function into Power BI. This function lets us change dimensions in visuals with a simple click on the slicer.

Continuing on my exploration of field parameters, in this post I want to share how you can use field parameters and modelling to dynamically sort columns in a table with a slicer and also switch ro…

I show how using different Power BI DAX queries gives you the same result, one DAX measure uses a lot of resources and the other uses almost nothing.

This article explains how to use KEEPFILTERS to intersect instead of override an existing filter context in DAX. Using KEEPFILTERS simplifies the code and i

Context transition is one of the most obscure topics for DAX newbies. Learn how it works, its effects, and how to leverage it rather than be scared of it.

To group some data in the report, it is very common to create a custom column or a calculated column based on specific conditions, and then put this column in a slicer to filter visuals. This would generate more data in the model and the group result is fixed. If the data used in the conditions is f...

In many businesses, sales don't come in equally distributed over the year. Learn how to deal with Forecasting with seasonality in Power BI.

Imagine you bought a brand new, top of the line red Ferrari, but in place of a performance driver's seat, it came with a $10 folding lawn chair installed... 26 comments on LinkedIn

Dynamics 365 CE, and Model Driven Power Apps built on Dataverse can create views to be filtered to only show records where a username field on that record, such as 'owner' equals the current user. (e.

It's a terrible title, but by the end I hope it makes sense Today I had some spare time and I thought I would do some c# that is always good to keep your mind going.  The goal was to create a script that given a base measure, you can then specify a column and a new measure will be generated for e

Context transition is one of the most obscure topics for DAX newbies. In this article we introduce context transition, its effects, and how to leverage it r

In this post, we will take a step by step approach to simplify a report with 6 pages + 12 measures into 1 page report + 1 measure. After optimising the report, we will explore a change that will …

Building a Dynamic KPI card with Calculation Groups allows to modify the base measure as well as the transformations to use for comparison.

Reduce the number of measure you create by using Calculation Groups in Power BI. This blog will guide you through to get started.

CALCULATE is the most powerful and complex function in DAX. In this article, we provide an introduction to CALCULATE, its behavior, and how to use it. CALCU

One of the powerful features of the Tabular data model is to extend the model by adding calculated columns and measures. Both objects are defined using DAX, but besides this similarity, they are entirely different beasts. Here you will find guidance when to use what!

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!

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

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

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…

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

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

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,

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

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

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 »