Forum Discussion
Solved
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...
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 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!
