Forum Discussion

ben-t's avatar
ben-t
Frequent Visitor
4 years ago
Solved

Count based on max date

Hi all ,  I'm trying to do a distinct count of locations based on their last status date. the locations need to fufil 3 criteria, prefix, dept and changedate before the max slicer date selected Eg...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    ben-t , if date table is not joined

     

    new measure =
    var _date = MAXX(allselected('Date Table'), 'Date Table'[Date])
    return
    CALCULATE(distinctCOUNT(Locations[locations.location]),FILTER(Locations, Locations[locations.changedate]<= _max))

     

    if joined with date on change date

     

    new measure =
    var _date = MAXX(allselected('Date Table'), 'Date Table'[Date])
    return
    CALCULATE(distinctCOUNT(Locations[locations.location]),FILTER(all(Date Table'), 'Date Table'[Date]<= _max))

v-xiaotang's avatar
v-xiaotang
Community Support
4 years ago

Hi ben-t 

Have you solved your problem? If yes,  could you kindly mark the answer helpful as the solution? 
If not, could you provide more details about your problem? so that we can work on it further. Thanks.


Best Regards,
Community Support Team _ Tang