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…
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…
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…
The COUNT function in DAX is nice and easy. Let’s learn what it does (I think you can guess what it does) so we can all use it when we need it in our DAX measures. We’re using a very simple dataset to learn the COUNT function. If you’d like…
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…
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…