DAX Measures

[Chapin4u]

Hi, I have two PBI reports that have the same tables each but I have been requested to consolidate the two reports in one. So I must write all the measures from report b to report a. Is there any way I can use DAX Studio to list the measures and its formulas? Thanks for the help.

[Seth_C_Bauer · Accepted solution]

@Chapin4u With DAX studio you can connect to the report that you need the measures from to figure out what the instance and db name are. Then you can connect to that and enter in this query to extract the measures from the model. 

Select [Name], [Expression] from $SYSTEM.TMSCHEMA_MEASURES

Then you can copy/paste or export to excel for whatever your needs.

[Chapin4u]

Wow @Seth_C_Bauer! You are great, thanks! It worked beautifully!