How to modify current month sales expression return more then 20K ?

[admin11]

Hi All

_Sales Current Month =

VAR _MIN =

EOMONTH ( TODAY (), -1 ) + 1

VAR _MAX =

EOMONTH ( TODAY (), 0 )

RETURN

TOTALYTD (

( [SALES_] ),

'Date'[Date],

FILTER ( 'Date', AND ( 'Date'[Date] >= _MIN, 'Date'[Date] <= _MAX ) )

)

[amitchandak · Accepted solution]

@admin11 , use a visual level filter

or try a measure like

_Sales Current Month =
VAR _MIN =
EOMONTH ( TODAY (), -1 ) + 1
VAR _MAX =
EOMONTH ( TODAY (), 0 )
Var _res = TOTALYTD (
( [SALES_] ),
'Date'[Date],
FILTER ( 'Date', AND ( 'Date'[Date] >= _MIN, 'Date'[Date] <= _MAX ) )
)
RETURN
if(_res> 20000, _res, blank())