You can remove redundant measures from a query with the Remove Measure option. Uncheck the measure(s) that are not required in target reports.
.png)
Remove measures
The COGS measure has been removed from the query.
.png)
Measure removed from the query
You can also remove measures with the Pivot table option.
