How to Calculate Capped Quantity in Power BI

A step-by-step guide for creating a measure that limits the actual value to the planned value.

Introduction

Power BI is a powerful tool for data analysis and visualization. One of the common tasks that users may encounter is to create a measure that calculates the capped quantity, which is the minimum of the planned and the actual values. This measure can be useful for comparing the performance of different products, regions, or time periods, and for identifying the gaps between the targets and the results.