thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Data & Analytics · Advanced

Semi-Additive Measure

A fact that can be summed across some dimensions but not across time, such as account balances or inventory levels.

Definition

Summing a balance across months is meaningless, so semi-additive measures use the last, first or average value over time. DAX uses functions such as LASTNONBLANK, CLOSINGBALANCEMONTH or LASTDATE with CALCULATE.

Example

Inventory on hand: sum across warehouses, but take the closing value across days.

Exam tip

For balances and headcount, use last-value logic over time, not SUM.

Related terms