In this blog, we are going to dive into row context in DAX Power BI. Another way to call it is the iterating calculation engine, but it is called row context from a more technical perspective. DAX Power BI: Row Context & SUMX The way that you get into row context is by using iterating
In this article, we will review how to find the percent of the total calculation in Power BI. Although you might have already learned this from the other modules, reviewing it would be beneficial for its common usage in various scenarios. Percent Of Total In Total Sales To show you a simple example, we will
In this blog post, I’ll touch on some simple aggregations in Power BI that you can use in your DAX calculations. This is a continuation of the blog that I previously published, where I covered the differences between a measure and a calculated column. I’ll first continue working on the measures that I’ve gone through
Now, let’s delve deeper into one of the most important concepts in Power BI calculations — the aggregations. Power BI aggregations are formulas used to calculate a single summarized value from multiple rows that are grouped together. There are different ways to create aggregations in Power BI. Some of the examples of aggregation functions are
In this blog, I’m going to compare Power BI calculated column and measures, and then cover some of their differences. I’m also going to show you optimal situations where you can use either of them. Creating Calculated Columns I’m going to start by creating a calculated column in Power BI. This is probably what you’re
