Context sensitive dynamic formatting for measures

It's commonly known that you can provide a format string for measures like in the following example:

with MEMBER [Measures].[Sales Amount Fmt] AS  [Measures].[Sales Amount],
FORMAT_STRING = "$0,000",
NON_EMPTY_BEHAVIOR = { [Measures].[Sales Amount] }

select  [Measures].[Sales Amount Fmt] on 0,
[Product].[Subcategory].[Subcategory] on 1
from [Adventure Works]

The important part of the example above is the FORMAT_STRING property. Here, it formats our measure sales amount as a dollar value without positions after the decimal point and with a separator for thousands.

The result looks like this:

Read more - Part 2...