on 03 Nov 2017 22:39:23
It would be nice to be able to click on a measure and see all other measures that are using that measure. Kind of like Query Dependencies, but for measures.
I have several hundred measures, and many of them are using the same base measures, this would help with diagnosing issues when I have to change one of those base measures. Thank you!
- Comments (5)
RE: See everywhere a measure is being used (Measure Dependencies)
This would be helpful. I am new to working with Dax and create multiple expressions in order to find how to write it correctly. Now I have multiple measures with 1,2,3, after them and I am not sure which one I can delete without looking at all tab and other measures to see if they are using the measure I want to delete.
RE: See everywhere a measure is being used (Measure Dependencies)
The model analysis tab in RadaCad's Power BI Helper will provide a measure dependency tree. Very helpful and free.
RE: See everywhere a measure is being used (Measure Dependencies)
Critical need to quickly find all reports/charts/views and associated DAX references for a Measure name.
RE: See everywhere a measure is being used (Measure Dependencies)
Not only the measures using the selected one, but the visuals that use it too. Would be very useful, like in Visual Studio where we can find every single line in the entire project that references a property or method
RE: See everywhere a measure is being used (Measure Dependencies)
A bit late on the response but there is a way to do this. If you have DAX studio, you can
click on the DMV Tab on the bottom >> Double click "MDSCHEMA_MEASURES" >> Run the Query
The result will show you all your formulas in powerBI. You can export the output and voila!