IGLOO BI

The reason we learn the ALL function in Power BI is not just to simply remove filters. It is to establish a Grand Total as a universal reference point and clearly understand the relative position of each item within that context. In the previous post, we looked at the performance structure between products through Mix (Share) and Ranking analysis. In particular, by combining the ALL and RANKX functions, we established a Global Ranking from a company-wide perspective and verified what position each product occupies within the overall sales structure. In this post, we intend to go one step further and expand the horizon of our analysis. The protagonist is Pareto analysis, which uncovers the point of strategic decision-making by using the ALL function to clear filters for "Share," the RANKX function to grant "Order," and then "Accumulating" these results. This process of finding the basis for "Selection and Concentration" beyond a simple listing of...

In Power BI, ranking analysis goes beyond simple data sorting; it is a vital method for understanding market structures. While a simple sales report focuses on the past record of "how much was sold," ranking analysis answers more critical questions: Which of our products is the number one bestseller? What percentage of total sales do the top 20% of products generate? How much has this month's rank changed compared to last month? How does the ranking of popular products differ from store to store? To answer these questions, you must use the RANKX function in conjunction with the ALL function. The ALL function plays an especially crucial role in ranking analysis because it restores data hidden by filters, creating a "complete competitive landscape that includes invisible competitors." Power BI Ranking Analysis Series This series consists of five practical analysis parts: Part 1 — Global Ranking (RANKX + ALL) -- Current Post Part 2 — Top-N & Others (Pareto) Par...

In the previous post, we summarized the two faces of the ALL function: the Filter Modifier and the Table Provider. Today, as our first practical pattern, we will master "Mix & Share" analysis—the most widely used technique in the field—and the design of Performance Indices derived from it. The purpose of this post is clear: "When you calculate shares accurately, your sales strategy changes." This is not just a list of formulas. It is a full-course guide starting from DAX design based on actual sales data, moving to numerical verification, and ending with strategic interpretation.   1. Why is Mix Analysis Important? 1.1 Mix is Not Just a Simple Percentage  Simple sales figures are merely results, but "Share" is a map for designing the future. Through Mix analysis, we obtain management answers to the following questions. We calculate share for one reason: to see the structure. Store Mix: How much does each store contribute to total sales? Product Mix:...

In the world of Power BI, the decisive turning point that separates beginners from pros is the ability to leverage the ALL function. While many beginners understand ALL simply as an "eraser that wipes away filters," pros use it as a "strategic tool to redefine the foundation of calculation." Today, as a data analyst, I will perfectly summarize the five core patterns of the ALL function that can be applied immediately in the field.   1. The Essence of the DAX ALL Function: Filter Modifier vs. Table Provider Inside the engine, the ALL function possesses two powerful identities: Filter Modifier: Inside a CALCULATE function, it ignores existing filters (such as slicers) and redefines the baseline for calculation. Table Provider: It re-summons the original data that was filtered out and supplies it as a virtual table to serve as the raw material for calculations. When these two identities meet practical business scenarios, the following powerful analytical metrics are ...