In this blog post, I’ll introduce you to DAX table functions. Table functions are simply DAX functions that return a table. Some of the most common table functions that you can encounter in Power BI are the FILTER, VALUES, and ALL functions. Using these table functions, you can create virtual tables inside Power BI. Physical
This tutorial will go through an advanced example on the DAX function RANKX in Power BI. This is a breakout session from the Learning Summit Workshop in Enterprise DNA Online. The RANKX function gives you valuable insights when you use it for a range of different contexts in your report page. However, it can also
Conditional formatting is a way of visualizing data by applying a certain set of format rules based on user-defined conditions. For Power BI visuals, it is mostly used when presenting data in a tabular form. In this tutorial, I’ll discuss how to combine DAX formulas with the new conditional formatting feature to highlight the last
The ALLSELECTED DAX function inside Power BI is one of the more advanced functions that you can utilize within your reports and dashboards. ALLSELECTED DAX function is a derivative of the ALL functions. So there’s ALL, ALLSELECTED and ALLEXCEPT. They all do something similar, which is remove the context or filters. Here, we’ll focus on
This blog post will show you how to use the ALL function in Power BI to effectively showcase unique insights and differentials in your numbers. We’re going to dive into the average order size for the sales we may be making across a variety of different products. This tutorial will also show you how to
