In this tutorial, I want to show you what the CALCULATE function can do through a few examples. CALCULATE is one of the most frequently used functions in Power BI. It dictates the context being applied to any measure and removes any existing filters in place. Using CALCULATE Function For Total Sales To truly understand
I want to focus today on something I call the hidden DAX trap. If you encounter this situation, it will make you feel like you’re losing your mind because your DAX is going to look right, but it’s not going to work. I’ll walk you through when that occurs and what you can do about
In this tutorial, I’m going to show you some advanced ranking analysis in Power BI. As an example, I’m going to use the report that I submitted for the 10th Power BI Challenge on the Enterprise DNA forum. I have discussed the other pages in this report in other tutorials. For now, I would like
In this tutorial, you’ll learn how to add elements for vendor analysis in your inventory management dashboards using DAX formulas. Previous blogs have discussed how to set up the data model and the code used to get stock reorder analysis. The next details you need to focus on are the vendor tables. You have a
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
