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)
RE: Measure Dependency View (similar to the Query Dependency View)
This ia great idea when you develop a model!!! But there is another one, when you explore a model. Create Calculated Fields groups in the fields tab. When the number on calculated metrics increases it is almos impossible to remember the measures you already have. The filter helps but is not enough. I would like to see something were I can group all metrics. Like this
Sales
Actuals
Signed $
Current Month Signed $
MTD Signed $
QTD Signed $
Processed $
Proposed $
Budget
Variance to Budget (VTB)
Forecast
Variance to Forecast (VTF)
Sales Forecasting Reliability
Forecast Accuracy %
Forecast Predictability%
Projected Sales
Predicted Sales
In my model, just to describe the different status, steps and time calculations linked with one Company "Sales", I have developed more than 250 different calculated metrics. It is tough to see from dependency perspective, and from presentation perspective
RE: Measure Dependency View (similar to the Query Dependency View)
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17237591-between-option-on-dates-is-not-working-on-timeline - vote this
RE: Measure Dependency View (similar to the Query Dependency View)
play now
http://www.head-soccer.com/
RE: Measure Dependency View (similar to the Query Dependency View)
Yes, Yes, and Yes. Necessity when you have a lot of measures in your model.
RE: Measure Dependency View (similar to the Query Dependency View)
Now that I have 16 measures I consider this necessary. But I can control it yet.
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