Forum Discussion
AS Tabular Model connection - PBIX report with additional measure
- Anonymous2 years ago
Hi 101Mathew ,
To quickly identify all the measures created in the report file, you can use DAX Studio.
In DAX Studio, click MDSCHEMA_MEASURES.
Enter the following SQL statement:
SELECT * FROM $SYSTEM.MDSCHEMA_MEASURESAfter executing this SQL statement, you can get a list of all measures.
For more details, please refer to this video:
(1) Document your Power BI Desktop models with DAX Studio! - YouTube
I recommend:
For convenience, create an empty table before creating a measure, and then put all the measures you create in the future into this table.
For more information about creating a measure table, please refer to:
https://powerbidocs.com/2020/10/22/create-a-measure-table-in-power-bi/
If you have any other questions please feel free to contact me.
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
Hi 101Mathew ,
To quickly identify all the measures created in the report file, you can use DAX Studio.
In DAX Studio, click MDSCHEMA_MEASURES.
Enter the following SQL statement:
SELECT * FROM $SYSTEM.MDSCHEMA_MEASURES
After executing this SQL statement, you can get a list of all measures.
For more details, please refer to this video:
(1) Document your Power BI Desktop models with DAX Studio! - YouTube
I recommend:
For convenience, create an empty table before creating a measure, and then put all the measures you create in the future into this table.
For more information about creating a measure table, please refer to:
https://powerbidocs.com/2020/10/22/create-a-measure-table-in-power-bi/
If you have any other questions please feel free to contact me.
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!