Filter context is one of the major topics that any Power BI user should initially learn about, especially if you want your DAX calculations to work effectively. In this article, I will run through the filter context. Every DAX formula is calculated in a two-step process. DAX Formula: A Two-Step Process The first step is
In this tutorial, I will cover the two places where you can write your DAX formulas. These two places are the calculated columns and measures. I will go over each one at a time and I’ll start with calculated columns. Using Calculated Columns A calculated column is an additional column that doesn’t exist in your
Power BI What-If parameters are a really powerful feature to implement in your models for scenario analysis. Scenario analysis is immensely important from an analytical perspective in Power BI and ‘What-If’ parameters allow you to quickly implement tables and measures for this type of analytics. Once you select the What-If parameter icon, it opens a
Query parameters are a really strong feature in Power BI. There are many places that you can implement filters in Power BI, but on some occasions, it’s better to do this at the query layer versus the report level. You might want to create filters at the query level if you have massive tables from
I want to show you how you can use filter fields and visual interactions in Power BI to great effect. They create simple and very effective ways to make your visualizations easier and more intuitive for the consumer especially if we need to create groupings of information in our analysis. Filter fields enable you to
