Tag: DAX Calculations

Custom Dynamic Segmentation Using DAX In Power BI

In this blog post, I want to go over an advanced DAX pattern about how to create custom dynamic segmentation in Power BI. You can apply this great technique to many scenarios to gain meaningful insights. Dynamic groups are created when a range of different customers are segmented based on different metrics like sales, margin

Continue reading

A Deep Dive Into How The ALLSELECTED DAX Function Is Used In Power BI

The ALLSELECTED DAX function inside Power BI is one of the more advanced functions that you can utilize within your reports and dashboards. ALLSELECTED 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 the difference

Continue reading

Show Top Or Bottom Results Using Ranking In Power BI

In this tutorial, we are going to dive into how to utilize ranking techniques effectively in Power BI. Sometimes you don’t want to show all the results from your data in your visualization. Sometimes you only want to see the top or the bottom results, for example the top five or the bottom seven. To

Continue reading

How To Use Iterating Functions To Fix Total Issues In Power BI – DAX Concepts

How To Use Iterating Functions To Solve Total Issues In Power BI - DAX Concepts

I’m going to show you today how to use iterating functions when you’re trying to fix Total issues in Power BI. When I go through the questions posted on the Enterprise DNA support forum for members, I see a lot of people having issues with the Totals they get on their report regardless if they’re

Continue reading

Create Reports In Power BI To Show Deviations And Insights

In this tutorial, I want to show you how to set up compelling visualizations using deviations in your reports in Power BI. These are some really powerful insights that have historically been very difficult to complete and highlight in combination. I’m also going to look to highlight these specific deviations and what is causing the

Continue reading