Database Reference
In-Depth Information
igates to the
Internet Sales
table and gets all the related rows for those
products; for this set of rows, it applies the calculations. The model adds
up all the
Sales Amount
values and then performs the
Net Profit
and
Net Margin
calculations within the context of rows related to
Accessor-
ies
. Does this make sense?
2. Leave Excel open so we can keep using it.
Understanding Filter Context
Now that you have the concept of Row Context, you shouldn't have any trouble un-
derstanding its cousin, Filter Context. To get started, I'll introduce an important DAX
function called
CALCULATE
.
Search WWH ::
Custom Search