Tag: Measure Branching

Use Measure Branching To Speed Up Report Development

In this tutorial, I’m going to show you how I maximized a technique called measure branching to speed up my report development process on my submission for the 10th Power BI Challenge. The Power BI Challenge is a series of scenarios where a data set is provided and participants are asked to deliver the set

Continue reading

Time Period Analysis – Intro To Problem Of The Week #10

WORKING W TIME TABLES DAX PROBLEM

In today’s blog, we’ll discuss Problem of the Week #10. The problem of the Week is an ongoing series where we solve real-world scenarios through DAX and Power Query. This week, we’ll deal with a time period analysis. You may watch the full video of this tutorial at the bottom of this blog. The problem

Continue reading

Percentage Of Total Using ALL And ALLSELECTED

Percentage Of Total Using ALL And ALLSELECTED

In this tutorial, I’ll discuss the difference between ALL and ALLSELECTED DAX functions when calculating the percentage of total in Power BI. The difference between these two DAX functions can be relatively confusing when you’re just starting out with Power BI. Hopefully, this tutorial can give you some clarity on this matter. You may watch the full

Continue reading

VALUES Function (DAX) In Power BI

VALUES-Function-DAX-In-Power-BI

In this tutorial, I’ll discuss how the VALUES Function (DAX) allows you to create useful automation when working on a model with multiple date measures. You can watch the full video of this tutorial at the bottom of this blog. The VALUES function (DAX) returns a one-column table that contains the distinct values from the

Continue reading

Calculate Percentage Margin In Power BI Using DAX

Calculate Percentage Margin In Power BI Using DAX

Today, I’m going to do a quick and easy tutorial on how to calculate one of the most commonly used metrics, especially if you’re dealing with sales, revenues, or transactions. We’ll calculate the percentage margin. I’m going to use profit margin as an example here, but this technique doesn’t have to be always related to

Continue reading