Forum Discussion

wimsangers's avatar
wimsangers
Icon for Helper I rankHelper I
5 years ago
Solved

Date Filters do not work when + 0 is added

Hi all,   I am trying to calculate the occupancy rate per hour per location. I have managed to do so using the following formula DISTINCTCOUNT('bi chargesession (2)'[evse_id])/DISTINCTCOUNT('EVSE...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    wimsangers , +0 forces left join.

     

    I try this kind of measures in the past

    0 between range
    Measure = var _1= SUM(Opportunity[Opportunity count]) +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))

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

wimsangers , +0 forces left join.

 

I try this kind of measures in the past

0 between range
Measure = var _1= SUM(Opportunity[Opportunity count]) +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))