Create compound measures in PowerBI
Published
•1 min read
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
