Skip to main content

Power BI

Needs Votes

See everywhere a measure is being used (Measure Dependencies)

Vote (85) Share
Steven Willard's profile image

Steven Willard on 03 Nov 2017 22:39:23

It would be nice to be able to click on a measure and see all other measures that are using that measure. Kind of like Query Dependencies, but for measures.

I have several hundred measures, and many of them are using the same base measures, this would help with diagnosing issues when I have to change one of those base measures. Thank you!

Comments (5)
Steven Willard's profile image Profile Picture

Denise Kresge on 06 Jul 2020 00:12:01

RE: See everywhere a measure is being used (Measure Dependencies)

This would be helpful. I am new to working with Dax and create multiple expressions in order to find how to write it correctly. Now I have multiple measures with 1,2,3, after them and I am not sure which one I can delete without looking at all tab and other measures to see if they are using the measure I want to delete.

Steven Willard's profile image Profile Picture

Michael Colbert on 06 Jul 2020 00:04:54

RE: See everywhere a measure is being used (Measure Dependencies)

The model analysis tab in RadaCad's Power BI Helper will provide a measure dependency tree. Very helpful and free.

Steven Willard's profile image Profile Picture

Deborah S Judy on 06 Jul 2020 00:04:33

RE: See everywhere a measure is being used (Measure Dependencies)

Critical need to quickly find all reports/charts/views and associated DAX references for a Measure name.

Steven Willard's profile image Profile Picture

Gabriela on 05 Jul 2020 23:39:28

RE: See everywhere a measure is being used (Measure Dependencies)

Not only the measures using the selected one, but the visuals that use it too. Would be very useful, like in Visual Studio where we can find every single line in the entire project that references a property or method

Steven Willard's profile image Profile Picture

avalon d'souza on 05 Jul 2020 23:25:13

RE: See everywhere a measure is being used (Measure Dependencies)

A bit late on the response but there is a way to do this. If you have DAX studio, you can

click on the DMV Tab on the bottom >> Double click "MDSCHEMA_MEASURES" >> Run the Query

The result will show you all your formulas in powerBI. You can export the output and voila!