Tag: Measure Branching

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 percentage margin. I’m going to use profit margin as an example here, but this technique doesn’t have to be always related to profits;

Continue reading

Data Visualization Technique | Power BI Dynamic Visuals

Data-Visualization-Technique-_-Power-BI-Dynamic-Visuals

I want to show you a data visualization technique that I believe is one of the best that you can do in Power BI. There are so many techniques now compared to when I first created this technique, but to me, this still has a lot of positives to it and it can really showcase

Continue reading

SELECTEDVALUE DAX – Harvesting Slicer Selection

SELECTEDVALUE-DAX-–-Harvesting-Slicer-Selection

In this tutorial, I’ll show you how to harvest or capture a value inside a measure to reuse in another measure and achieve dynamic calculations. I use a combination of measure branching technique with SELECTEDVALUE DAX function in Power BI. You may watch the full video of this tutorial at the bottom of this blog.

Continue reading

Advanced DAX Functions: Calculating Profit Contribution

In this blog, I’ll be discussing some more advanced DAX functions to demonstrate what’s possible in Power BI. You may watch the full video of this tutorial at the bottom of this blog. This tutorial will teach you how to visualize the profit contribution of different client tiers using advanced DAX functions. DOWNLOAD DAX RESOURCE

Continue reading

Combining DAX Patterns Or DAX Formulas In Power BI

For this tutorial, I’ll be showing you how to combine multiple DAX patterns in Power BI. This strategy is one of the many applications of measure branching and is an effective way of producing high-quality reports. You may watch the full video of this tutorial at the bottom of this blog. When your goal is

Continue reading