Power BI DAX: ALL

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…

Read More

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…

Read More

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…

Read More

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…

Read More

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…

Read More

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…

Read More

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…

Read More