INFO.MEASURES DAX function in Power BI

The INFO.MEASURES() function in DAX is part of the INFO family of functions, which are designed to provide metadata about a data model. Specifically, INFO.MEASURES() retrieves a list of all measures defined in the current model.

INFO.MEASURES() returns a table containing detailed information about every measure in the model. Each row in the resulting table corresponds to a single measure, and the columns provide metadata about that measure, such as its name, expression, and other properties.

Syntax INFO.MEASURES()

Since INFO.MEASURES() returns a table, it must be used within a DAX query that can handle table output, such as with the EVALUATE statement. For example:

DAX

When executed, this query will return a table listing all measures in the model.

Returned Columns Some of the returned columns are described below:

• Name: The name of the measure.
• Expression: The DAX expression defining the measure.
• TableID: The ID of the table to which the measure belongs.
• Description: Any description provided for the measure (if defined).
• IsHidden: boolean indicating whether the measure is hidden from the client tools.
• Format String: The format string applied to the measure (e.g., currency, percentage).
• Other metadata: Additional properties like modification date, DataType, DisplayFolder are also included.

Use Cases

• Model Documentation: Automatically generate a list of all measures in a model for documentation purposes.
• Debugging: Inspect measure definitions to troubleshoot errors or inconsistencies.