show item with no data - not showing data properly in visual

[Anonymous]

Hi,

I need Rolling Date i.e Values from Current Month (october 2022) to next year previous month (september 2023).

I have created a calculated column for rolling values, if it lies in between then it is "yes", else "no". In filter pane I have selected 'yes" by default.

When I am selecting "Item with no data" in visualization pane for Date field, it is showing all the month with zero values irrespective of rolling DAX field.

How to solve this problem?   

[amitchandak · Accepted solution]

@Anonymous , You can add +0 to your measure and try

example

[Your measure] +0

or

0 between range
Measure = var _1= [Your measure] +0
var _min = minx(ALLSELECTED('Calendar'), 'Calendar'[Date])
var _max = maxx(ALLSELECTED('Calendar'), 'Calendar'[Date])
return
CALCULATE(if(max('Calendar'[Date]) <_min || max('Calendar'[Date]) >_max , BLANK(), _1))