DAX Tables for Measures




Experts recommend storing measures in a dedicated set of tables. It makes the data model organized and user friendly.



Measures stored in multiple tables as per the category

Notice the different symbol for DAX tables as compared to the regular tables













Creating DAX tables:

Home > Enter Data



Enter the name of the table:


Use special characters like “@” or “_” in front of the table name as it keeps the DAX tables at the top of the Field lists.

Formatting DAX table

Add a new measure in the table by clicking on the table name > New Measure



Post adding one measure in the table, delete the Column 1



Collapse and expand the Fields pane to update the icon of the DAX table.


You can have multiple DAX tables in a data model.


How to move existing measures?

Each measure has a home table, which is the physical location. In simple words, the measure lives in the table. However, the location of measures does not impact the measure’s output. Hence, it is advisable to move all measures in their dedicated tables.

Change the home table:

Select the measure > Measure Tools > Home Table


Select the new table where we want to move the measure.




Drop Me a Line, Let Me Know What You Think

 

contact@vivran.in

+91 9871-641-146

Join WhatsApp group: BI Simplified

MS EXCEL || POWER BI || POWER APPS || POWER QUERY || TABLEAU || DATA ANALYTICS || TRAINING