This is a combined solution that you can use to identify unused objects in a pbix file. The scope is to identify those measures and columns from your report that are not used at all and could possibly be removed.
Steps we need to follow to gather the necessary information:
Here I can run different queries, but I didn’t find this enough for what I need, so I will only take some results and use them in the final solution.
In our final report, I have created 3 pages: for Measures, for Calculated columns, and another one combining both measures and calculated columns.
Please note that this method does not consider the measures and calculated columns used in Query Editor or Filter Pane, so you need to take a look in both places before you decide to remove an object.
This method allows us to combine useful outputs from DaxStudio, Power BI Performance Analyzer and Power BI and have it all in the same place. It offers a clear view of what objects we are not using anymore in our reports and helps us clean up our data model.
Cat image credit https://wallpaperaccess.com/cat-laptop