Hi, it is easy to create a calculated measure and also to delete it if you do not need it anymore.
And when you use a an existing column in a powerpivot there is also automatically a measure created.
Example:
Sum of ColumnName
:=SUM('TableName'[ColumnName])
But when the column is taken out of the pivot this automatically created measure is not deleted. So if I list all measures also the not used automatically created measures get still listed, even though they are not used anymore.
I do this listing especially for files with many measures to keep an overview and also as a safety measure for an easier reconstruction in case pp gets unchangeable. In order not to bloat the list it would be good if these not used automatically created measures could be eliminated.
Hi Matthias,
What version of Excel do you have? I don't get this behaviour in Office 365.
Mynda
Hi Mynda,
I am non 2013. And the measures are listed by PP Utilities (List measures): https://www.sqlbi.com/tools/power-pivot-utilities/
Thanks,
Matthias
So when you say the measure is listed after being removed from the PivotTable, do you mean it is still listed in the PivotTable field list, or do you mean the PP Utility is still listing it in the static list it creates in the workbook?
PP Utility is still listing them in the list it creates in the workbook.
This sounds like a PP Utility issue, not a Power Query issue. You need to go back to the provider of PP Utility with your request as there is nothing I can do about how PP Utility has been set up, sorry.
Mynda
The VBA works on the current file status, no storing, no reference to previous lists, nada => no chance of forgetting to delete old records on the VBA side.
The VBA is "simply" reading record sets from ActiveWorkbook.Model.
sQuery = "SELECT DISTINCT [MEASUREGROUP_NAME] as
