The CALCULATE() function - Application

The CALCULATE() function - Application

Creating measures for our sample model using CALCULATE()

When to use

You want to practice using the CALCULATE() function

Instructions

Create a multi-row card and add the Sales $ measure

Create the following measures and add them to the multi-row card:

Single filter CALCULATE() measures

• Sales $ - Draft = CALCULATE([Sales $],Categories[Category]="Draft Beer")
• Sales $ - Btl Beer = CALCULATE([Sales $],Categories[Category]="Bottled Beer")
• Sales $ - Can Beer = CALCULATE([Sales $],Categories[Category]="Canned Beer")

Multi-column CALCULATE() measures

• Squintz Draft $ v1 = CALCULATE([Sales $],Locations[Location Name]="The Squintz",Categories[Category]="Draft Beer")
• Squintz Draft $ v2 = CALCULATE([Sales $ - Draft],Locations[Location Name]="The Squintz")

More complex CALCULATE() measures

• Sales $ - 1-4PM = CALCULATE([Sales $],Sales[Hour]>=13 && Sales[Hour]<=16)
• Sales $ - Beer v1 = CALCULATE([Sales $],Categories[Category]="Draft Beer"||Categories[Category]="Bottled Beer"||Categories[Category]="Canned Beer")
• Sales $ - Beer v2 = [Sales $ - Draft]+[Sales $ - Can Beer]+[ Sales $ - Btl Beer]

Hints & tips

• Building measures on measures allows complex logic without having to write super complex formulas