Access extended properties of a selected measure in a calc group.

[bcdobbs]

In a similar way to how we have SELECTEDMEASURENAME() and SELECTEDMEASUREFORMATSTRING() is there a way to access the extended properties of a measure from a calculation group. I'm using a calc group to apply formats dynamically and can exclude measures by name or using SEARCH but would like to be able to set an extended property of "IGNORE FOR CALC GROUP" or something similar.

Thanks

Ben

[bcdobbs]

Thanks for the reply.

Wondering if we're talking about the same thing here...

[jaweher899]

it is possible to access the extended properties of a measure from a calculation group. You can use the DAX function CALCULATE(SELECTEDMEASURE(), 'Measure Table'[Extended Property]=value) to access the extended property value of the selected measure. Replace 'Measure Table' with your measure table name, and 'Extended Property' with the name of the column that contains your extended property, and 'value' with the desired value of the extended property.

You can then use this formula in a calculated column or measure to conditionally include or exclude the measure from your calculation group based on its extended property value.