In a Matrix like above there are many places where you can show/hide values, when we think of it there are mainly 5 areas, Rows, Columns, Rows Total, Column Totals, and Grand Totals, but you can have many more levels by some boolean tricks. So how do we control where exactly to show a value or which area to hide them from? by using ISINSCOPE. This function not only tells whether you're grouping by a certain column at certain level but you can use it as boolean mask or an inte

In this blog let's take a look at how you can Fill blank cells with values before or after them also know as Fill Up or Fill Down in various tools.

DAX has 2 functions that allow you to JOIN tables and columns i.e. NATURALINNERJOIN & NATURALLEFTOUTERJOIN, although there is no...

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

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

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

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

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

Recently I faced a situation where a simple measure such as COUNTROWS was returning a blank, yeah what's up with that? COUNTROWS...

DAX language of Power BI and SSAS Tabular doesn't have a function for Full Outer Join so in this blog we are going to see a work around...

In this article let's take a look at how to get started with aggregations feature in Power BI. I will try to explain aggregations in a...

Recently someone asked a question that whether they should store a column in a Tabular model in String or Integer format and in this short blog I just want to help you decide it by yourself. In Power Query I have create 2 tables with different data types Let's load these tables in the data model and open DAX Studio and view the vertipaq Analyzer metrics. We can see that both column have a Dictionary encoding: The size of the dictionary varies however, the overall size mention