Class ModelMeasure (Excel VBA)

The class ModelMeasure represents a single ModelMeasure object in the ModelMeasures collection. To use a ModelMeasure class variable it first needs to be instantiated, for example


Dim mme as ModelMeasure
Set mme = ActiveWorkbook.Model.ModelMeasures(Index:=1)

For Each

Here is an example of processing the ModelMeasure items in a collection.


Dim mme As ModelMeasure
For Each mme In ActiveWorkbook.Model.ModelMeasures
	
Next mme

AssociatedTable


ActiveWorkbook.Model.ModelMeasures(1).AssociatedTable =

Delete

Deletes the model measure from the data model.


ActiveWorkbook.Model.ModelMeasures(1).Delete

Description

The description of the model measure.


ActiveWorkbook.Model.ModelMeasures(1).Description =

FormatInformation

The format of the model measure.

The formatting of the model measure can be of type:


ActiveWorkbook.Model.ModelMeasures(1).FormatInformation =

Formula

The Data Analysis Expressions (DAX) formula of the model measure.


ActiveWorkbook.Model.ModelMeasures(1).Formula =

Name

The name of the model measure.


ActiveWorkbook.Model.ModelMeasures(1).Name =