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) )))

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

Are you want to filter the table by slicer or do the calculation by slicer?

Please show some sample data and expected result to us.

 

Best Regards,

Jay