Tag: DAX Measures

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

Implementing DAX Measure Groups Into Your Reports – A Power BI Modeling Review

In this tutorial, I’ll be talking about a really important topic regarding Power BI modeling and organization. In most of the demos that Enterprise DNA releases across webinars, summits, and to Enterprise DNA members, you will see that the use of measure groups is extensive. There is a very good reason why measure groups have

Continue reading

Fixing Incorrect Totals Using DAX Measures In Power BI

Getting totals correct inside Power BI reports can sometimes be the most frustrating thing when utilizing DAX measures. You might probably get into certain situations where your Totals for DAX measures aren’t adding up the way you want them to.  DAX measures can be based on standard aggregation functions, such as COUNT or SUM. These

Continue reading

Using Advanced Logic In Power BI To Correct Your Totals

Many times when you get into more advanced formula with DAX, you’ll find that the totals that show up either on a table or a card can sometimes be incorrect. There are so many variations of how this could eventuate in your formulas so it’s hard to cover every single scenario. In this tutorial, I

Continue reading

Multiple What If Parameters In Power BI

Do you want to see how advanced you can get with Power BI? In this tutorial, I want to show you my favourite way to use Power BI. You can do some amazing work around scenario analysis by integrating what if parameters in Power BI — things like sales, profits, or transactions. Not just because

Continue reading