Query field descriptions

The following query can be used to retrieve the measures in a dataset with descriptions as well as their DAX expression:

SELECT        [Name] as [Measure Name]  ,    [Description] as [Measure Description]   ,    [Expression] as [DAX Expression]FROM$SYSTEM.TMSCHEMA_MEASURESWHERE LEN([Description]) > 1ORDER BY [NAME]; 

As shown in the following screenshot, the query can be executed from DAX Studio against the open Power BI Desktop file:

Measure descriptions via DMV query in DAX Studio

The WHERE clause in this query ensures that only measures with a description applied are returned. Removing or commenting out this clause (for example, ...

Get Mastering Microsoft Power BI now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.