Forum Discussion

jj_0511's avatar
jj_0511
Helper I
3 years ago

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 ...
Need Help
jj_0511's avatar
jj_0511
Helper I
3 years ago

Can someone else or someone from Microsoft confirm this:  filter condition of the calculate function over writes the outer filter condition even when they are on different columns in same table?

jj_0511's avatar
jj_0511
Helper I
3 years ago

Any experts here can shed some light on this?