Set Analysis- Sum with Conditions

[Arvind_07]

Hi,

I use the following expression to sum a field called [Sch Remaining Qty] based on recent date from the [Run date] field for [material number] dimension.

sum({<[Run Date]={"$(=Max([Run Date]))"}>}[Sch Remaining Qty])

P.S. [Run Date] field contains last 7 days values

But my question is if I use the Run Date field on the Filter pane - Is it possible to modify the above set expression to give me the sum of values based on the filtered date otherwise it should give me the sum of values based on recent date from the [Run Date] field by default(when no filters are applied on the [Run Date] field)

Could someone help me out please. 

Thank you

[tresesco · Accepted solution]

If your expression above is working for no-selection scenario, it should also work the way you want when you select a  date from the field. Have you tried and checked?

[Arvind_07]

Yea it is..:D Thank you