Display Blanks as zero giving unexpected result - DAX help

[rveerasamy]

in my monthwise ipad usage trend report currently not showing the blank values.  i want to dispaly the blanks as zero. So i created the below measure , applied the page level filter order date after 2019 and mm/yy column coming from our date master table. but it's giving unexpected result from 2017. it should display only from 2019/01 

Ipad orders = IF(ISBLANK(CALCULATE(DISTINCTCOUNT(Sales[Order Id]),Sales[IPAD_ORDER]="IPAD")),0,CALCULATE(DISTINCTCOUNT(Sales[Order Id]),Sales[IPAD_ORDER]="IPAD"))

Please help me on dax

[amitchandak · Accepted solution]

@rveerasamy , Try like

Assumed slicer on date of date tbale

measure =
var _mes =CALCULATE(DISTINCTCOUNT(Sales[Order Id]),Sales[IPAD_ORDER]="IPAD")+0
var _min = minx(allselected(Date), Date[Date])
var _max = maxx(allselected(Date), Date[Date])
return
if(max(Date[Date]) >=_min && max(Date[Date]) <=_max, _mes, blank())