Identify which measure we are not using in our PBIX Report

[Anonymous]

Hi Experts

Is it possibe to use either DAX Studio and or another method to find out which measure we are using in a particular Power BI PBIX File and which measure we coudl remove.

[Anonymous · Accepted solution]

Hi @Anonymous ,

You may try:

• Use DAX Studio

1. After opening the pbix file in Power BI Desktop, Go to File->New in DAX Studio.

2. A "Connect" dialog will appear. Select "PBI / SSDT Model" radio button and select the pbix file name from the drop down list. It will show all the pbix file that are currently open. 

3. Click "Connect" button.

4. Once you connect all the tables and measures in your data model from the pbix file will be listed on the left side.

5. Right-Click the table name that you want to check for dependencies and select the "Show Objects That Reference Table" option from the context menu that appear.

6. Step 5 will create a query and when you click run from the ribbon, it will list all the dependent tables, relationships, measures etc... that dependents on the selected table in "Query Result" tab.

• Use Tabular Editor

Install the free program Tabular Editor. Once installed, open your report and navigate to External Tools --> Tabular Editor. In Tabular Editor, navigate to a measure in the left pane, right-click and select "Show dependencies".

For more information, please refer to:

https://ssbi-blog.de/blog/technical-topics-english/how-to-identify-measures-not-used-in-your-pbix-file/

https://www.sqlbi.com/articles/capturing-power-bi-queries-using-dax-studio/

https://www.thebiccountant.com/2020/01/01/tidy-up-power-bi-models-with-the-power-bi-cleaner-tool/

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Many Thanks Excellent feedback,....
can you kinldy have a look at - no can answer the question -  https://community.powerbi.com/t5/Desktop/TRICKY-Rolling-12-Months/m-p/1969830#M746142

[parry2k]

@Anonymous check this tool Power BI Helper - RADACAD

✨ Follow us on LinkedIn

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡