KPI Default Selection

[ltc]

I need to adjust the expression for my KPI, which is currently:

Sum({<[Category] = {'Direction'}, [Date] = {'3/1/2018'}>} [Value])

I hard-coded the date in the expression, but that's not what I want.  What I want is the following:

If a selection is not applied, I want the default selection to be the max Date.  However, if a Date selection is applied, then I want that to show on the KPI.

The data set is attached.  

Thanks!

[ryo_okabe · Accepted solution]

Hi,
Try this.

Sum({<[Category] = {'Direction'}, [Date] = {'$(=Max(Date))'}>} [Value])