Forum Discussion
jj_0511
Helper I
Helper IHow filter argument in CALCULATE interact with outer filter context on different col in same table
Hello: I have two tables: Date: sample data: Date Month Year 2023-01-01 Jan 2023 2023-01-02 Jan 2023 ... ... Sales: Date Sales 2023-01-01 9 ...
Ashish_Mathur
Super User
Super UserHi,
If there is a conflict between the inner and outer filter (which is clearly your case), then the filter condition of the calculate function over writes the outer filter condition. To reverse this, you may either use the KEEPFILTER() or the FILTER() function.
jj_0511Helper I
Helper ISo the filter condition of the calculate function over writes the outer filter condition even when they are on different columns? Is this behavior documented anywhere?
- Ashish_Mathur
Yes, that is what it looks like. Not sure of where this is documented.