Measured Values are a way of restricting the results of a Measure to a given scope of Filters and/or Members.

 

Syntax

( <Measure>, <Scope1> [, <Scope2>...] )

Parameters

<Measure> : A Measure or a Custom Measure.

<ScopeN> : A Member, Group of Members or a Filter.  Each <ScopeN> must belong to a different Dimension.

Description

Evaluates the value of <Measure> in the scope of the given <ScopeN> parameters.

 

---

Example

Consider the following raw data:

Product	Store	Sales
Shoes	Store A	10
Shoes	Store B	20
Shoes	Store C	30
Shirt	Store A	40
Shirt	Store B	50
Pants	Store A	60
Pants	Store C	70

( [Sales], [Store A]) = 110 {10+40+60}

 

( [Sales],[Store A and Store B] ) = 180 {10+20+40+50+60}

[Store A and Store B] is a Group containing Store A and Store B.

 

([Sales], [Store A and Store B], [Shoes] ) = 30 {10+20}

[Store A and Store B] is a Group containing Store A and Store B.

 

( [Sales], [Products with Sales > 60] ) = 220 {90+130}

[Products with Sales > 60] is a Filter by Criteria returning only products with totals sales greater than 60 (Shirt=90 and Pants=130)

See Also