How to know which measures are not at all used in the report (Not used in the viz + no dependents)

[smpa01]

Hello experts,

While creating a big report, I created some measures (let's suppose 50). Out of all those measures I am only using 15 in the viz window and 15.

Is there a way for me to know

A. On which other measures each of those 15 measures have a dependency?

B. if I can obtain those retrievd in step A, I am only going to keep them and 15 and delete the rest.

Is it currently possible to do quickly rather than manually go through each and every measure to find out the dependency ?

Thank you in advance.

[mwegener · Accepted solution]

Hi @smpa01 ,

look at this.

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

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[smpa01]

Super @Marcus. Will try it out and let you know. Thanks for the help.

[mwegener]

Hi @smpa01 

If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[smpa01]

@mwegenerdidn't have a chance to test out. Been a crazy week !!! Will let you know though eventually.

[smpa01]

@mwegener @ImkeF  tried the tool https://www.thebiccountant.com/2020/01/01/tidy-up-power-bi-models-with-the-power-bi-cleaner-tool/ . It is amazing. Thanks @ImkeF  for this aweome tool.

This does a pretty good job but I saw some attributes not appearing on FieldUsageDetails table but they are used in the visual like below

where used directwhere used indirect

But the same measure is present in a viz

Visual container

Anyway , this is a very good strat. Power BI currently does not have anything (like Tableau) which tells the dependecies of a particular measure. Imke has done a great job to address that.

[ImkeF]

Yes, that's a current known limitation (see documentation in blogpost:

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

Thanks for testing!

[smpa01]

Hello @ImkeF ,

One followup question, I am currently trying to figure out out of 200 measures initially created in a report how many were not at all utilized.

When I analyzed my pbix using your tool, in field usage details table it did not return some measures at all (measures that does not contain brackets in their name) . Is it safe to conclude that those measures were not at all used and the ones with brackets in their name need to be cautiously processed before drawing any conclusion.