topic Re: Where is my measure being used in DAX Commands and Tips

Where is my measure being used

pedroccamaraDBI — Mon, 07 Mar 2022 11:52:05 GMT

Hello everyone. I hope everyone's ok.

In my pbi file, i'm beginning to have a lot of measures and reports (9 so far).
Is there anyway of knowing where's my measure being used, so i can delete it or change it safely, for example?
Thanks a lot

Re: Where is my measure being used

johnt75 — Mon, 07 Mar 2022 12:05:24 GMT

You can use Tabular Editor to show any other columns or measures which depend on a given measure - just right-click on the measure and choos Show Dependencies.

You can use https://powerbi.tips/product/field-finder-tool/ to see which visuals are using a measure. By combining the two you should be able to identify any measures which aren't being used any more.

Re: Where is my measure being used

MattAllington — Tue, 08 Mar 2022 00:52:50 GMT

Search for Imke Feldman's Power BI Cleaner tool. I'm pretty sure it does this.

Re: Where is my measure being used

pedroccamaraDBI — Tue, 08 Mar 2022 18:40:26 GMT

Fantastic tool MattAllington
Such a pleasure to get an answer of one of the DAX masters
Thank you so much
Stay safe and healthy

Re: Where is my measure being used

pedroccamaraDBI — Tue, 08 Mar 2022 18:42:02 GMT

Fantastic MattAllington
Such a pleasure to get an answer of a top DAX master
Thank you so much
Stay safe and healthy

Re: Where is my measure being used

alagator28 — Tue, 30 Jul 2024 16:25:13 GMT

Thank you! I was sure Tabular Editor could help and had it installed and running but couldn't figure out where. Much appreciated.