How to track in which visuals measures have been plugged on

[Anonymous]

People,

I want to know if there is any feature that shows in which visuals my measures and calculated columns are being used?

I also wanna take a look at the measure tree in order to check how many measures and calculated columns are positioned downstream the main measure.

Is there anything like this on PowerBI or DAX Studio?

[Anonymous]

@Anonymous 
There is no such features to check whether measures and columns are used in a report. In case you publish the report on Power BI and then connect from other reports or from Excel, then it will be impossible to track such a dependency in any case.

However, if you want to track the dependencies in DAX, you can use VertiPaq Analyzer. It extracts all the DAX expressions for calculated columns, measures and calculated tables. Then you can search in the list. I am not sure is this something you want. 

Try check the discussion in the post, might helpful: Determine which measures are used in a report

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Purpose is different but this should able to help

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

[Fowmy · Accepted solution]

@andrekroker

I'm not sure if the following tools what that feature you're looking for, please try:

https://radacad.com/power-bi-helper

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

________________________

If my answer was helpful, consider accepting it as the solution to help other members find it

Click the Thumbs-Up icon if you like this answer 🙂

Youtube Linkedin