Creating Measures

In this lesson we will be using DAX to create measures. Here are the formulae you will use in class

• $ = SUM(GL[Amount])

• -$ = -1 * [$]

• Revenue = CALCULATE([$], Account[Level3] = "StdIncome")

• COGS = CALCULATE([-$], Account[Level2] = "Cost of Sales")

• Gross Margin = [Revenue] - [COGS]

If you skipped previous lessons, you can start by downloading the pbix file.