- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Definition and example of filter context
Hi,
I am trying to understand what filter context is and have some questions becasue I see different examples and different explanations.
On sqlbi.com , filter context is explained as "The filter context is the set of filters applied to the data model before the evaluation of a DAX expression starts."
If this is the case, why is it that filter conditions in CALCULATE function are considered filter context ? It is a part of DAX expression, isnt it ?
Also, if CALCULATE is considered filter context, why is FILTER fuction not considered filter context ?
FILTER function can also add filter conditions just like CALCULATE, correct ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

I read the article but it does not really answer my question. My question is still, why is CALCULATE considered filter context when the definition is
"the set of filters applied to the data model before the evaluation of a DAX expression starts."
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@hideakisuzuki01 , Have you checked this blog?
http://dataap.org/blog/2019/04/22/difference-between-calculate-with-and-without-filter-expression/

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
10-02-2024 03:18 AM | |||
08-15-2024 06:08 AM | |||
08-05-2024 04:04 PM | |||
10-01-2024 05:48 AM | |||
05-09-2024 04:52 PM |
User | Count |
---|---|
141 | |
112 | |
83 | |
63 | |
47 |