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.

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.

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.

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

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

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.

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.

People often struggle when using conditional formatting and calculation groups. If we think how calculation groups work there's many ways to use them effectively.

It is possible to filter a matrix by a measure, but may lead to unexpected results. See one such case and a possible workaround with a calculation group.

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

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

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.

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 »

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

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

To set the stage, I need you to travel back in time with me a bit.The year was 2019, and none of us had ever heard of COVID-19…those were simpler times.I was working on a data model that had A LOT of …

What you can do and why you should Have you ever been facing the problem of showing small and large numbers together (e.g. 123,456, 789.99 and 34.56) in a nice way, lets say with a 3 digit precison as 34.5 and 123G (or 123E6).   When working with large numbers you can divide them with 1,000 or 1,000...

In this blog post, I will give you a comprehensive overview on the Power BI calculation groups. I’ll share with you some of my tutorials around calculation groups and you’ll see how and when to use them.    Calculation groups are a collection of items, which are basically the same measures that you ...

To set the stage, I need you to travel back in time with me a bit. The year was 2019, and none of us had ever heard of COVID-19…those were simpler

When I first started learning about Calculation Groups, I could certainly see how much potential this new DAX feature would eventually have. Out of the gate however, there were a limited number of …

This blog post details how to create the default format string with calculation groups when no items are selected in Power BI

This article shows how to use calculation groups to change the active relationship in a model in order to let users choose among multiple dates. It is commo

As the name suggests, a multi-kpi comparator allows you to compare multiple KPIs or measures on the same chart. This way you can dramatically reduce the clutter on your Power BI report page. You ca…

Calculation groups are a robust modeling feature in Power BI that reduces redundant measures created by grouping standard measure expressions.

This article describes how to use calculation groups to dynamically replace only a partial expression in a complex DAX calculation. This article contains a

I was playing around with calculation groups for a question. I found that adding a calculation group is not that straightforward as it should be, so I decided to blog...

One of the cool things of calculation groups is they cannot just be used to apply a calculation over your “base measure” but also apply a dynamic formatstring. You could...