One dimension that affects a measure

[Amit_B]

Hi,

How can I create a measure that is only affected by selection in only 1 field?

For example, a measure that shows the sum of sales. If we choose a value in the Year dimension then the sum will changes, but if wr choose a value in other dimensions (Month, Store, etc.) then there will be no change.

Thanks.

[qv_testing]

Try this

SUM({<Month=, Store=>}Sales)

If user select Month and Store value will not change.

If you have any other dimension to exclude write like DimensionName=

[Amit_B]

I try to do the opposite, to use the dimensions for which the value will change. There are many dimensions that I don't want to affect the value, I don't want to mention them all.

[qv_testing · Accepted solution]

Try this

=Sum({1<Year=$::Year>} Sales)

[Amit_B]

Thank you! You made it a lot easier for me.