DAX

This article describes how to compute visual totals accurately, in case a measure does not provide the right result at the total level but works correctly i

If you ever spend time looking at DAX generated by the Power BI Desktop Performance Analyser, you may notice a function called KEEPFILTERS appear from time to time. It’s not a function I find…

I was working on a project a wee bit ago that the customer had conditional formatting requirement on a Column Chart.They wanted to format the columns in the chart conditionally based on the average value based on the level of hierarchy you are at.Here is the scenario, I have a Calendar hierarchy as below: Calendar … Continue reading Highlighting Below Avg Sales per Hierarchy Level with SWITCH() and ISINSCOPE() DAX Functions in Power BI

Much like the pieces on a chess board – to the novice, they represent individual units with different capabilities. Over time (or so I’m told) as experience is gained through tournament…

Back in 2018, when I wrote a detailed post on how to create nested display folders for measures in Power BI, I mentioned that unlike in Analysis Services it was not possible to make a Power BI meas…

One of the common patterns of a data model is the subscription pattern. In this pattern, we have subscriptions (or tickets, or issues, or whatever else you want to call it) open date and close date. The way that this data is stored in a table makes it a bit challenging to get informative insight…

In this blog post, I'm sharing a technique to display text as values in a multi-row card and still have the special Card Title.

COALESCE is a DAX function introduced in March 2020. This article describes the purpose of COALESCE and how to simplify DAX expressions by removing verbose

In the previous article/video, I explained how to create dynamic bins by choosing the count of bins in a slicer in the Power BI report. In this article, I'll explain, how you can do it the other way around, which is by selecting the size of the bin, you will have bins and buckets dynamically…

Banding (or binning or grouping) is a scenario that can be implemented both statically and dynamically in Power BI. Dynamic banding means selecting the bin (or band) configuration, and the banding changes based on the user selection of the slicer. Imagine that we have a count of customers by their age groups, but then we…

One of the most common types of banding or binning is banding based on a range. Let's say, for example, you want to have a group of customers based on their age group. The age group banding can be created in Power Query at the data transformation stage. It can be created using the Grouping…

9 PowerBI tips to help you manage and perfect your PowerBI, DAX and analysis skills.

Showing how the use of the Aprrox Distinct Count is a lot faster than using the DISTINCTCOUNT that is native to DAX measures.

Quick note to the Power BI developers looking to up their DAX game… I’ll be presenting a new session – Power BI Time-Intelligence: Beyond the Basics – to the following user …

Much has been said about DAX, and even more will be told, as DAX still evolves and the adoption of tools that are using DAX like Power BI and MSFT Analysis Services Tabular is growing. This series of blog posts are inspired by questions asked on https://community.powerbi.com. These questions are touching the most foundational concepts and are reminding me of my journey into the realm of evaluation context, filter propagation, data lineage, the scope of variables, and the mysterious world of table iterators, just to name some concepts. Sometimes it seems that these foundational concepts are ...

Okay, the title of this blog post could also have been "SUMX returns unexpected results with duplicates". The results only seem incorrect because an incorrect assumption might have been made. Let's dive into the issue with an example. The Problem Suppose we have employees entering timesheet da

This article describes how to implement currency conversion for reporting purposes in Power BI. Currency conversion applied to reporting can include many di

One of the interesting calculation challenges in BI systems is a segmentation or grouping on a numeric value, based on an occurrence of another value. As an example; You might want to know How many customers ordered once, twice, three times or more. The challenge is that the data in the transactional table is not…

In the previous part of this article, I explained what is the segmentation challenge, when you want to group data based on the aggregated result, and I explained a static method of creating aggregated tables and creating a relationship to the main detailed table. However, the caveat of that method is the segmentation is done…

Learn how to determine if your revenue growth is good by checking if your margins expanded using Power BI measure branching.

This article describes the types of relationships available in Power BI and Analysis Services, clarifying the differences in cardinality and filter propagat

We asked our team for their favorite shortcuts when writing DAX in Power BI Desktop, and listed them in this DAX shortcut guide to boost your productivity.

DAX Formatter was created in 2013 to help users format their code based on the Rules for DAX Code Formatting published in October 2012. Because the main goa

This article explains the behavior of LASTNONBLANK, LASTNONBLANKVALUE, and similar DAX functions, also providing patterns for performance optimization. The

DAX Conditional functions: Learn how to create conditional statement in DAX for Power Pivot or Power BI using AND, OR, IN and the syntax && and ||