Using model's metadata to create table

Hi Anonymous ,

Sorry for my late reply ... You could follow these steps.

1.Use the following Query code in DAX Studio(the pbix file should be run )

SELECT
[Measure_Name] as [Metric],[Measuregroup_Name] as [Table],[Description],[Expression]
from 
$SYSTEM.MDSCHEMA_MEASURES 

ORDER BY [Measure_Name];

2.Clike OutputàFile and Run again, the results will be save as Text file.

3.Then you could get data from the Text file

You could take a look at these two articles for more information.

https://insightsquest.com/2017/12/14/query-power-bi-field-descriptions/

https://exceleratorbi.com.au/getting-started-dax-studio/

Did I answer your question ? Please mark my reply as solution. Thank you very much.

If not, please upload some insensitive data samples and expected output.

Best Regards,

Eyelyn Qin