CALCULATE

Oct 193 min read

Why DAX is returning 100%

In this blog let's take a look at why your DAX calculations are returning 100% instead of a fraction of the grand total. In DAX you can...

Understanding how Time Intelligence functions are evaluated in Row Context

Antriksh Sharma

May 168 min read

Understanding how Time Intelligence functions are evaluated in Row Context

I have been thinking about this for a while, a series of blogs where I try to explain how a particular piece of DAX code works. For this...

Using DETAILROWS with WINDOW functions in DAX

Antriksh Sharma

Apr 134 min read

Using DETAILROWS with WINDOW functions in DAX

DAX doesn't have the concept of global variables so reusing a piece of code by referencing it somewhere else isn't possible, luckily the...

Applying a Filter on Dimension vs Fact in DAX

Antriksh Sharma

May 10, 20234 min read

Applying a Filter on Dimension vs Fact in DAX

While working with DAX, a common mistake that anyone makes (that I also made) is to think that applying a filter on a column of a...

Antriksh Sharma

Apr 28, 20231 min read

ALL Functions vs Security in DAX

One thing that we are used to is ALL functions ignore filters and return either a unique value or complete table when used as a table...

Previous Year calculation in case of missing years in DAX.

Antriksh Sharma

Aug 3, 20212 min read

Previous Year calculation in case of missing years in DAX.

One of the most common time intelligence calculations that I see in each report is that of Previous Year, this calculation is pretty easy...

How to create Running Total in Power BI: The Basics

Antriksh Sharma

Jul 12, 20214 min read

How to create Running Total in Power BI: The Basics

In this tutorial lets see how easy it is to create a running total in DAX either in SSAS, Power Pivot or Power BI. Running total is a...

Optimizing calculations involving CROSSJOIN in DAX for Power BI, Power Pivot and SSAS.

Antriksh Sharma

May 29, 20215 min read

Optimizing calculations involving CROSSJOIN in DAX for Power BI, Power Pivot and SSAS.

In this blog I am going to show you how you can optimize a simple measure involving CROSSJOIN and in the process we are also going to...

Antriksh Sharma

May 24, 20213 min read

Inverse SUM in DAX

In this blog let's see how to compute value of the measure for every other value of a column except for the one that is currently visible...

Circular Dependency between Calculated Columns in a Table in DAX

Antriksh Sharma

May 4, 20215 min read

Circular Dependency between Calculated Columns in a Table in DAX

In this article let's understand what Circular Dependency is and how it can cause issues when creating Calculated Columns in a Fact table...

Compute PARALLELPERIOD without using PARALLELPERIOD in DAX

Antriksh Sharma

May 1, 20213 min read

Compute PARALLELPERIOD without using PARALLELPERIOD in DAX

PARALLELPERIOD is a DAX function that allows you to shift MONTH, QUARTER, or YEAR based on the the dates visible in the filter context,...

How to create Running Total on Non-Numeric Fields in Power BI using DAX

Antriksh Sharma

Apr 9, 20213 min read

How to create Running Total on Non-Numeric Fields in Power BI using DAX

Creating running totals on a numeric or date field is pretty easy because you always have something that you can use to compare against...

How To Exclude Slicer Selection from the result with DAX in Power BI

Antriksh Sharma

Apr 9, 20217 min read

How To Exclude Slicer Selection from the result with DAX in Power BI

One of a very common requirement that I have seen is to be able to filter out the selection made in the slicer from a visual such as a...

Antriksh Sharma

Mar 21, 20211 min read

DAX | CALCULATE | March’ 2021 Update

Effective March update of Power BI you can specify different columns in the single filter argument of CALCULATE without writing the...

Thinking Behind Use of KEEPFILTERS in DAX

Antriksh Sharma

Feb 23, 20212 min read

Thinking Behind Use of KEEPFILTERS in DAX

In this blog let’s understand why you should use KEEPFITLERS more often. Below is the snapshot of the data model ( Contoso Retail Data...

Power BI DAX: Context Transition - Behind the scenes

Antriksh Sharma

Jan 20, 20215 min read

Power BI DAX: Context Transition - Behind the scenes

Context transition — one of the most complex topics to understand and master but have you ever wondered, what actually happens behind the...

Running Totals exclude days from the calculation

Antriksh Sharma

Nov 22, 20208 min read

Running Totals exclude days from the calculation

Creating a Running Total is pretty simple in DAX, you just take a measure, wrap it inside CALCULATE and then with the help of DATESYTD...

www.antmanbi.com