How to find idle measures?

[Applicable88]

Hello,

I know this question might be asked very often, but still I hope there is a newer updated approach then many other more complicated solutions:

As some of you maybe like me,  not always deleting idle measures and want to keep the code for reference or so.....

and at the end of your visualisation project you end up having tons of unused and measures and calculated columns/tables.

To find a way sorting them out before you publish it might seem to be a scary task, since one missing element e.g. measure seems to be idle but it is actually inside another measure for another calculation needed. 

How you guys do it? Is there a efficient approach, without running in danger to mess up you visualtisation?

Thank you very much.

Best. 

[amitchandak · Accepted solution]

@Applicable88 , Refer if these can help

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

https://radacad.com/power-bi-cleanup-tool-time-saving-with-power-bi-helper

[Applicable88]

hello @amitchandak, 

as always thank you very much for your quick response. I took a look in the PowerCleaner Tool. I will follow the whole procedure the mentioned tool. 

Thank you!