Set Expression to change value in KPI using multiple Filters

[yashpace]

Hi, I have three filters for date, week and month and I would like to change the count of Distinct ORDNUM as user select any of the above filters 

 I am trying this in Current KPI (Total Orders Dispatched) - 

Count({1} DISTINCT {<ORDNUM = {"=[NewOrderDate] = [NewDispatchDate] or [Week] = [WeekNewDispatchDate] or [Month] = [MonthNewDispatchdate]"}>} ORDNUM)

My filters respectively are- NewOrderDate. Week, Month (Here week and month are calendar values created by me ) 

This is giving me count of month if I select any date or week.

TIA!!

[sugathirajkumar]

can you pls try it with $ current selection?

[yashpace]

Hi, 

I tried -

Count({$} DISTINCT {<ORDNUM = {"=[NewOrderDate] = [NewDispatchDate] or [Week] = [WeekNewDispatchDate] or [Month] = [MonthNewDispatchdate]"}>} ORDNUM)

But still getting months count.