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 (37)
RE: Measure Dependency View (similar to the Query Dependency View)
Fhcfg
RE: Measure Dependency View (similar to the Query Dependency View)
Had posted same idea some months ago :
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13816188-build-in-power-bi-model-over-pbix-files-for-metada
Glad to see this thread has more support.
I'll add a link from the "old" idea to this one so we can collect as many vote for this super important feature.
RE: Measure Dependency View (similar to the Query Dependency View)
Here here!! I have 600+ measures in my staging model and it's very difficult to debug at this point.
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