Forum Discussion
DAX Measures
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.
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.
2 Replies
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.
Wow Anonymous! You are great, thanks! It worked beautifully!
