Find the unused Measure/Data

[Anonymous]

Hi Power BI Community!

Is there a software/app or something in Power BI where I can find the unused measure/columns? 

I just have too many created at some point which are now unused and to find all of them manually would be a pain...

Thankx for your time. 

[Brunner_BI]

Use external tool Measure Killer to find and eliminate unused columns and measures

[v-yangliu-msft · Accepted solution]

Hi  @Anonymous  ,

You can create a list of this measures in DAX Studio to have a list of them, and use for retrieval.

This is the link to download and use Dax Studio:

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

There are related content and tools in the following link, I hope to help you：

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

https://exceleratorbi.com.au/measure-dependencies-power-bi/

https://exceleratorbi.com.au/which-columns-are-not-used-power-bi-data-model/

Best Regards,

Liu Yang

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

[amitchandak]

@Anonymous , refer if this old solution can help

https://community.powerbi.com/t5/Desktop/search-unused-columns/m-p/873136