A blog about Power BI, SQL Server Analysis Services (Multidimensional and Tabular), MDX, DAX, Power Pivot, Power Query, M, Power Map and Excel for BI

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

Video by: Reid Havens Learn how to apply some [DAX] wizardry to intelligently format string values when concatenating KPI values together. RELATED CONTENT 🔗 Kane Snyder's Calculation Group Presentation Jeff Weir's Twitter Post

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.

Overriding filters that are passed as filters in the tooltip opens new possibilities. This can be done for regular tables but also calculation groups.

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 »

Contribute to GreyskullAnalytics/Dynamic-Measures development by creating an account on GitHub.

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