Forum Discussion
How 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 ...
just your measure removes all filters
read about it here:
https://www.sqlbi.com/articles/introducing-calculate-in-dax/
https://youtu.be/HxZLkmpY6BA?t=270
your measure :
CALCULATE(
SUM(Sales[Sales])
, 'Date'[Date] = DATE(2023,5,1)
------
its complete syntax
CALCULATE(
SUM(Sales[Sales])
, FILTER(ALL('Date'), 'Date'[Date] = DATE(2023,5,1))
The complete syntax should be:
CALCULATE(
SUM(Sales[Sales])
, FILTER(ALL('Date'[Date]), 'Date'[Date] = DATE(2023,5,1))Still calculate filter and outer filter are on different columns in same table.