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)
Avi, great idea. I posted the following before I saw that it was a very similar suggestion...
Measures that reference and depend on other measures can be difficult to trace and debug. To make this easier, provide the option in the field list to show the measures that are referenced by other measures. This should be optional and performed individually for each measure to avoid unnecessary performance overhead. Here's a conceptual mockup:measure dependency (on my blog here: sqlserverbi.blog/2019/08/06/power-bi-product-suggestion-show-measure-dependencies/ )
RE: Measure Dependency View (similar to the Query Dependency View)
Definitely need this on Measures.
RE: Measure Dependency View (similar to the Query Dependency View)
This kind of functionality is crucial for building complex reports!
RE: Measure Dependency View (similar to the Query Dependency View)
More than a year later and this is still the best tool out there https://github.com/otykier/TabularEditor
RE: Measure Dependency View (similar to the Query Dependency View)
Great idea, where is it?!
RE: Measure Dependency View (similar to the Query Dependency View)
Impact Analysis, dependency, data lineage - all about tranparency into the data, understanding and trusting the data used in analytics. Enhances users' ability to create robust, meaningful analytics and drive business conversations and decisions.
RE: Measure Dependency View (similar to the Query Dependency View)
Once we have the dependencies, they should also be used when it comes to updating calculated tables/columns after changing e.g. a measure.
Changing a measure should not trigger a recalc of a calculated table where that measure was not used at all // has no dependency to
RE: Measure Dependency View (similar to the Query Dependency View)
It looks great.
RE: Measure Dependency View (similar to the Query Dependency View)
An addition to this idea is not only to view the dependency tree for the calculations, but also to view the visualizations dependent upon a measure. This would be extremely helpful for testing if a calculation changes and you need to regression test all the visuals within a workbook which contain those measures. This would also be helpful in getting rid of measures that are not used in your workbook
This could work similar to the "View Dependencies" right click menu selection in SQL Management Studio where you can see the tables, view, triggers, functions, and stored procs that are dependent upon the object or all of the tables, view, triggers, functions, and stored procs your object is dependent on.
RE: Measure Dependency View (similar to the Query Dependency View)
Hi Hugo,
It looks great.
Can you share the source for the recursive function ?