Measures are created in DAX by using the Measure formula. The syntax for this is:

MEASURE =

For example, a measure to calculate the total sales for a particular product can be created using the following DAX expression:

Total Sales = SUM(Sales[Sales Amount])

Calculated columns are created in DAX by using the Calculate formula. The syntax for this is:

CALCULATE =

For example, a calculated column to calculate the total sales for a particular product can be created using the following DAX expression:

Total Sales = CALCULATE(SUM(Sales[Sales Amount]))

Leave a Reply

Your email address will not be published. Required fields are marked *