I was just working on a client project where we have several complex measures that reference other measures. Sometimes it can be hard to keep all these dependencies in mind. As a feature, it would be great for Power BI Desktop to show these dependencies and navigate between them. After a quick search in the Power BI Community Ideas site, I posted a suggestion. Afterward, I found an older suggestion made by Avi Signh here: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/16783000-measure-dependency-view-similar-to-the-query-depe
Here’s my version in the mockup below. I think there’s a lot of potential to pile-on and add to this idea but I think that having a simple tree view of dependent measures would be a great start. If you agree, please vote this idea up on the Power BI community forum.
Show measure dependencies in the field list
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:
Thanks for the in depth knowledge on power BI. As I understand this involves lot of programming with various language and codes involved. Recently I encountered a BI tool which works on zero coding and tubeless architecture. How would you differentiate yourself with the tool I am referring
See model analysis tab of Power BI Helper for dependencies