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)
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 !!
RE: Measure Dependency View (similar to the Query Dependency View)
This would be very nice.
RE: Measure Dependency View (similar to the Query Dependency View)
Great idea, Avi. This has always been a challenge. You have my votes.
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
RE: Measure Dependency View (similar to the Query Dependency View)
Lineage is important.