Format DAX expressions for Power BI, Power Pivot and SSAS Tabular and explore inferred measure and column references. This helper is not a replacement for validation in the target model.
Format DAX expressions and visualize inferred dependencies between measures and tables.
The diagram shows inferred table and column references in your DAX expression. Drag nodes to arrange the view. Verify dependencies against the actual model.
SUM() — sum valuesCALCULATE() — evaluate with modified filtersFILTER() — filter a tableRELATED() — related valuesCOUNTROWS() — count rows'Table'[Column] — column reference[Measure] — measure referenceTable[Column] = Value — filter&&, || — logical operatorsBLANK() — blank valueEARLIER() — earlier row contextALL() — remove filtersVALUES() — distinct valuesFree tools for analysts and developers