Create compound measures in PowerBI

Create compound measures in PowerBI

Photo by Andrew Neel on Unsplash

A measure that makes reference to one or multiple measures is termed a compound measure.

In the given instance, you will adjust the Profit measure using the provided measure definition. Ensure the measure is formatted with two decimal places.

DAXCopy

Profit =
[Revenue] - [Cost]

Next, add the Profit measure to the matrix visual.

Now that your model provides a way to summarize profit, you can delete the Profit Amount calculated column.

By removing this calculated column, you've optimized the semantic model. Removing this columns results in a decreased semantic model size and shorter data refresh times. The Profit Amount calculated column wasn't required because the Profit measure can directly produce the required result.

SWETA SARANGI