dax

Use measures or Visual Calculations to replace blanks with zeros

DAX query view, released in public preview last month, in the December 2023 Power BI Desktop release has exciting updates including the new INFO DAX functions and improvements to the Update model CodeLens.

Automatic cross filtering between columns of the same table or related tables is a very powerful feature of DAX. It allows a measure to eval...

Dive deep into TREATAS DAX function in Power BI. Learn how to harness the power of CONCATENATEX and TREATAS for dynamic data filtering.

With the February and March 2023 Desktop releases comes more features enabling us to enhance our KPI visualisations out of the box. This article talks specifically to the DAX function LINEST() and the new Subtitle and Dividers formatting options. For a simple enhancement, we can add the divider to KPI Cards, without title and subtitle,… Continue reading KPI trend indicators on Core Visuals

Calculating the trend of a line chart can be possible using the Analytics tab under the format section of the chart. What if we need to store this calculation and reuse it or show it as a separate chart? Actual Chart as below The trend of the chart The first question is about calculating the Read more about Calculating the trend of a Chart using DAX ( Smoothing Moving Average)[…]

Hi, You may download my PBI file from here. Hope this helps.

Hi, This measure worksMeasure = COUNTROWS(FILTER(VALUES('Table'[ID]),CALCULATE(COUNTROWS('Table'),'Table'[status]="approve")=1&&CALCULATE(COUNTROWS('Table'),'Table'[status]="reject")=0)) Hope this helps.

Power BI introduced dynamic format strings in May 2023. In this article, we briefly introduce this functionality and then dive into a few technical details

Power BI introduced dynamic format strings in May 2023. In this article, we briefly introduce this functionality and then dive into a few technical details

The LINESTX DAX function simplifies the calculation of linear regressions. This article explains the correct way to manage its results efficiently. LINEST a

Seamless integration of Visual Studio and Tabular Editor means writing code in Visual Studio and getting it right for tabular Editor in just two clicks

This article describes how to optimize a text search operation in DAX. This technique can improve the performance of Power BI reports that use the contains

This article describes how to use the Group By Columns property to store the slicer selection by using the same column used in a SWITCH function to optimize

I always enjoy it when we get new DAX functions, especially so for the new set of WINDOW Functions recently added. As part of the April 2023 release of Power BI Desktop, we now have a RANK function and the ability to use a measure to control the order within the existing WINDOW function. The … Continue reading DAX Pareto Calculation

Comparing snapshots by state shows how many ids have moved from one state to another between 2 snapshots providing insights on bottlenecks.

The April 2023 release of Power BI desktop introduced a new preview feature called dynamic format strings for measures. This allows us to return values with different formats from the same measure.…

In this article, I clearly layout the differences when using FILTER or CALCULATE TABLE.

In this post we explore the advantage of using geometric mean over arithmetic mean in Power BI

This article describes how to implement a DAX measure to run faster than what you get from the built-in fusion optimization. In a previous article, we intro

ApproximateDistinctCount now works for BigQuery, Databricks and Snowflake sources in Power BI

When trying to get your DAX measures to work correctly, there are a number of tools you can use to debug, which I will briefly mention, but not go into depth on. Instead, this post is about how to think about debugging your code. I am focusing on DAX here, but many of the methods would apply to an

This article describes how Power BI uses the Group By Columns attribute of a column and how you can leverage it in specific scenarios. In Power BI you can s

In this post, I will describe how to implement Multiple Linear Regression in Power BI using DAX only.

In this post, I will describe how to implement Multiple Linear Regression in Power BI using DAX only.

Field parameters are amazing! Learn how to use this feature for data modeling purposes and enable users to have full flexibility in the way they want data displayed!

This article aims to show how you can speed up distinct count calculations in Power BI using the built-in user-defined aggregations feature. The user-defined aggregation feature in Power BI is designed to work with direct query models and usually gets used for calculations such as SUM, MIN, MAX etc. However, it can also work well … Continue reading Speed up Distinct Count calculations in Power BI using Aggregations

In this blog post I describe the new DAX function, LINESTX in Power BI and test it in a brief example. With the February Power BI update, two new DAX statistics functions have been introduced: LINEST and LINESTX. The functions use the Least Squares method to calculate a straight line that best fits the data, then return a table describing the line. The data result from expressions evaluated for each row in a table.

This article compares two common techniques to filter time periods in DAX: calculation groups and many-to-many relationships. A common requirement in report