Forum Discussion

berry195's avatar
berry195
Frequent Visitor
2 years ago
Solved

Filter() and AllSelected()

Hello, I want to to write a formula to calculate Running Total based on slicer. Nevertheless, I do not understand why one formula works, but the other one (which should be working) does not. Could so...
Need Help
  • amitchandak's avatar
    amitchandak
    2 years ago

    berry195 , when you have used Date in the filter section of calculate, without using the filter function, it has already considered all(Date[Date])

     

    so it is considering the dates which are not selected too

     

    refer: Difference in filtering data in CALCULATE with and without FILTER - https://youtu.be/KDcmzwgPvXQ

amitchandak's avatar
amitchandak
Super User
2 years ago

berry195 , when you have used Date in the filter section of calculate, without using the filter function, it has already considered all(Date[Date])

 

so it is considering the dates which are not selected too

 

refer: Difference in filtering data in CALCULATE with and without FILTER - https://youtu.be/KDcmzwgPvXQ