Procedure

1. Open DAX Studio.
   • If you haven’t installed DAX Studio on your computer, you can download the program here.
2. In the Connect dialog, enter the connection information for the data model.
   • If you are using a template app model, open the appropriate ‘with data’ file and select the PBI / SSDT Model option, then select the file from the dropdown menu.
     
     
   • If using a Data Warehouse (PPU) model, connect to the data model using the XMLA endpoint address found in the Power BI Service.
     
     
3. You will be prompted to sign in. Use the Power BI/Office 365 credentials from 1Password.
4. Once connected to the data model, in the bottom right-hand corner of the screen, select the DMV tab.
   
   
5. Search for measures drag TMSCHEMA_MEASURES to the query area.
   
   
6. Use the Output menu in the ribbon to choose how you want to see the query results.

• Click Grid to display the query results in the output section of DAX Studio.
• Click File to export the results to a .csv file.
  
  
• If sharing the file with a customer, you might consider deleting the columns of metadata and leaving Name and Expression. Alternatively, use the following query to return only those columns in the query results:

  select [Name], [Expression] as DAX_Code from $SYSTEM.TMSCHEMA_MEASURES