DAX Measures Lineager

×

How to use this tool

1. Copy the DAX Query to get the JSON export from your model:

           EVALUATE 
           { TOJSON(    
               SELECTCOLUMNS(
                   FILTER(
                       INFO.CALCDEPENDENCY()
                       , [OBJECT_TYPE] = "MEASURE" && [REFERENCED_OBJECT_TYPE] <> "COLUMN"            
                   )
                   ,  "Measure", [OBJECT]
                   , "Expression", [EXPRESSION]
                   , "Referenced_Object_Type", [REFERENCED_OBJECT_TYPE]
                   , "Referenced_Object", [REFERENCED_OBJECT]
               )
           , -1)}

   • Run this query in DAX Studio, Tabular Editor, or Power BI's DAX Query view.
   • Copy the output JSON result.
2. Paste or upload the JSON here:
   • Use content_paste Paste JSON or upload Upload JSON above.
3. Navigation:
   • Pan: Hold the middle mouse button (wheel) and drag (like Figma).
   • Zoom: Scroll with mouse wheel.
   • Drag nodes: Click and drag any box to reposition it.
   • Click a box: View DAX in the right sidebar; highlights dependencies.
   • Hover: Highlights a box under the mouse pointer.
   • Sidebar: Click outside any box to close.
   • Filter: Type to highlight matches (case-insensitive, blue border).
   • Filter Mode: Highlight highlights matches, Isolate shows only matches and their references.
   • fit_screen Fit to Content centers and zooms the diagram.
   • download Export PNG saves the diagram as an image.
   • help_outline Help shows these instructions.

Need help? Contact us at ibarrau@ladataweb.com.ar