Wrong values if Calendar Slicer is set to Between

[AndreiK15]

Hello everyone,

Why do I get wrong values if I set my Calendar slicer to between, but when select it to dropdown, will get the right value for Net Trans Amt?

Any idea?

Thanks!

[AndreiK15]

@v-xiaotang Thanks for replay, but I managed to solve the issue based on @amitchandak answer. I have removed filters and changed calendar table. 

[AndreiK15]

@amitchandakthanks for your quick replay... this is what I get and don't understand why it retruns the end of the year as max:

[v-xiaotang]

Hi @AndreiK15 

I cannot reproduce that behavior in my side. In my test, it returns

Measure = 
var _date1 = MINX(ALLSELECTED('Table'),'Table'[date])
var _date2 = MAXX(ALLSELECTED('Table'),'Table'[date])
return _date1&UNICHAR(10)&_date2

Could you please provide a .pbix file with that problem? Thanks

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@AndreiK15 , Create a new measure and put on card viusal and check diff between two

var _max = maxx(allselected('Date'),'Date'[Date])
var _min = maxx(allselected('Date'),'Date'[Date])
return

_max & " " & _min

If they are the same in both cases, share your measure to check.

Are you using some time intelligence functions?