Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Filter FactTable data dynamically based on date slicer

Hello to All,   I have been searching for solution to simple filter condition, have tried a lot of things by looking at different articals nothing worked, now I am confuse which one to give a shot ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , You can create a new measure

     

    measure =
    var _max = maxx(ALLSELECTED('Date'),'Date'[Date])
    return
    calculate(countrows(Table), filter(Table, ([StartOn]<=_max || StartOn = date(1753,01,01)) && ([Archieved] >_max Or ARCHIVED=date(1753,01,01) )))

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , You can create a new measure

 

measure =
var _max = maxx(ALLSELECTED('Date'),'Date'[Date])
return
calculate(countrows(Table), filter(Table, ([StartOn]<=_max || StartOn = date(1753,01,01)) && ([Archieved] >_max Or ARCHIVED=date(1753,01,01) )))