Skip to main content

Power BI

Needs Votes

Measure Dependency View (similar to the Query Dependency View)

Vote (984) Share
Avi Singh's profile image

Avi Singh on 24 Oct 2016 07:27:27

The newly introduced Query Dependency view is phenomenal but what we really need is a Measure Dependency view. Here is what it might look like: http://ppvt.pro/2eXKndh
And a video detailing this idea: https://youtu.be/sYjBB_Ef66M

In one of my production models I have 60 Queries, but I have 200+ measures! I believe that is typical; usually I build Queries and Measures as lego blocks, combining simpler ones into more complex ones needed in the end. In fact I needed it so badle that I attempted to build a Measure Dependency view using NodeXL. While that works, it's a lot of heavy lifting. How cool would it be, to just click a button on Power BI Desktop and see all your measures in a Dependency tree!

Comments (42)
Avi Singh's profile image Profile Picture

DAvid on 05 Jul 2020 22:33:00

RE: Measure Dependency View (similar to the Query Dependency View)

Avi, great idea and i am sure PBI pros would benefit from this. I mean we have 'DAX studio' to extract the measures and the 'biaccountant' has some great documentation techniques using sankey visuals see http://community.powerbi.com/t5/Desktop/How-do-you-document-your-models/td-p/23828

Avi Singh's profile image Profile Picture

Andrew Mackay on 05 Jul 2020 22:32:59

RE: Measure Dependency View (similar to the Query Dependency View)

Lineage is important.