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 (44)
RE: Measure Dependency View (similar to the Query Dependency View)
Great idea Avi. I have been waiting for this big time.
RE: Measure Dependency View (similar to the Query Dependency View)
Great idea, would simplify maintenance of complex models a lot
RE: Measure Dependency View (similar to the Query Dependency View)
Fantastic Idea.
Similar features as are available already in the table relationships view and the supporting dialog within PBI desktop would certainly enhance both the query and measure dependency views. The ability to use such a view to diagnose , troubleshoot and test various measure configurations without resorting to dax studio would be a significant product enhancement.
RE: Measure Dependency View (similar to the Query Dependency View)
Would love that
RE: Measure Dependency View (similar to the Query Dependency View)
good one
RE: Measure Dependency View (similar to the Query Dependency View)
An outstanding idea and a big, big timesaver when evaluating consequences to modifying a measure (or assessing the need to write a new measure)!
RE: Measure Dependency View (similar to the Query Dependency View)
Awesome work
RE: Measure Dependency View (similar to the Query Dependency View)
It would be a great tool
RE: Measure Dependency View (similar to the Query Dependency View)
This is an absolutely essential addition to Power BI. DAX is such a joy to write but when your measure is 3 or 4 levels deep, it can get very difficult to make changes.
RE: Measure Dependency View (similar to the Query Dependency View)
Great !!