PBI - DAX Studio导出measure tree

精华部分：

Once connected, you will see a list of tables in your Power Pivot Data model on the left.  The next step is to switch to the DMV tab down the bottom of the screen.

When you have clicked on the DMV tab, you will see a list of objects in the left hand panel.  Locate the one called MDSCHEMA_MEASURES and drag it into the editing pane on the right.

DAX Studio will then automatically write the query required to extract the Measures from the workbook.

Before executing the query you should change the output settings so it sends the results to a clean spreadsheet within your workbook.  When done, click the Run button to execute the query.

After you have run the query, you will notice there is a new sheet in your workbook that contains all the detail of your measures.

 

ref： Extract Measures from an Excel Workbook - Excelerator BI