GETPROMPTFILTER and GETPROMPTFILTERS

Use GETPROMPTFILTER to pass a filter (prompt) name and its user-selected value or values from a dashboard into an expression. GETPROMPTFILTERS passes all filter names and values for that specific dashboard.

GETPROMPTFILTERS is also useful in situations where the set of filters may change, and the measure expression does not have to change.

Passing Prompt Filters to Report Expressions:

Syntax:

[measure] WHERE GETPROMPTFILTER('filter_column_name')...

[measure] WHERE GETPROMPTFILTERS()...

Examples:

SELECT [Order_Date: Sum: Quantity] WHERE GETPROMPTFILTER('Time.Year')...

SELECT [Order_Date: Sum: Quantity] WHERE GETPROMPTFILTER('Time.Year') AND GETPROMPTFILTER(Products.Categories...

SELECT [Order_Date: Sum: Quantity] WHERE GETPROMPTFILTERS()...

For example, to divide the quantity sold for a particular retail region by the total sold, where the region value is a user-selected filter value.

([Order_Date: Sum: Quantity] WHERE GETPROMPTFILTER('Retail_Stores.Retail Region'))/[Order_Date: Sum: Quantity]

Caution:

For Designer you must use the name in the Prompt Properties Parameter Name field to refer to the prompt, not the Display Name.