The ALL function in DAX is a simple yet extremely versatile function that let’s us override any filters or slicers that may be affecting what data is coming into a calculation or visual. We’re going to learn how it works with a simple example using a CALCULATE function. (I…
Power BI DAX: DIVIDE
We’re taking on the simple yet incredibly useful DIVIDE DAX function today. This function has a cool piece in it that accounts for when your denominator is a 0. When you divide numbers in Excel, you’ll get at #DIV/0! error when your denominator is a 0 (because nothing can be…
Power BI Concept: Row Context
This post is about the concept of Row Context in Power BI. This is SUPER important when it comes to writing DAX measures, but applies to visuals not using DAX as well. To explore more DAX posts, check the DAX tag. This post was made with…
Power BI DAX: SELECTEDVALUE
This post is a high level look at the SELECTEDVALUE DAX function. This function is at once extremely simple and straightforward but can be used in a myriad of ways to filter data, indicate if data is filtered, even manipulate your report design to look different ways based on what…
Power BI DAX: CALCULATE
Knowing how to use the CALCULATE function is like knowing a cool super power. We’re going to learn the basics of it today, but it’s extremely versatile.The CALCULATE function performs a calculation on data but then lets you specify what data you want that calculation done on. Let’s try it out. We’re…
Power BI DAX: SUMX
The SUMX function in DAX is very similar to the SUM function (makes sense, right?) but with 1 key difference We’re going to use a very simple dataset to demonstrate how the SUMX function works.If you’d like to use the same data that I do in the below video, here…
Power BI DAX: SUM
In this post we’ll explore how to write a simple SUM formula using DAX, and also show an example of how you may want to use it. We’re going to use a very simple dataset and report to demonstrate how the SUM function works.The written instructions as well the Power…