Stagnant Fields

[fanninam]

I'm trying to get the correct syntax so that two specific fields will stay stagnant.  I need Site5 and BU5 to stay stagnant.

This is the original statement:

SUM({<[Metric Name] = {'Voluntary Turnover Total'}>}[Vol Terms/ Compa/ Promotions]) / SUM({<[Metric Name] = {'Voluntary Turnover Total'}>}[Average Hdct])

I tried the following but it ignores the Site5 and BU5:

SUM({<[Metric Name] = {'Voluntary Turnover Total'},Site5 = {'ESA'},BU5 = {'All ESA'}>}[Vol Terms/ Compa/ Promotions]) / SUM({<[Metric Name] = {'Voluntary Turnover Total'},Site5 = {'ESA'},BU5 = {'All ESA'}>}[Average Hdct])

[sergio0592]

For ignore selevtion on Site5 and BU5 filds , try with :

SUM({<[Metric Name] = {'Voluntary Turnover Total'},Site5 =,BU5 = >}[Vol Terms/ Compa/ Promotions]) / SUM({<[Metric Name] = {'Voluntary Turnover Total'},Site5 = ,BU5 = >}[Average Hdct])