Forum Discussion
Helper IReport filter vs. DAX FILTER()
Helper ISorry if I described my question in a somewhat unclear manner. Basically I wonder how the visual filters that I apply in the report affects the calculated measures and columns created by DAX expressions in the data view. It seems like the visual filters does not affect the measures and calculated columns, at least not in the same way as filters entered directly into the DAX expressions?
This is probably a broad and not very well-formulated question but I hope you understand what I mean. I have read the article suggested by I cannot find any specific info about visual filters in there. I would be very grateful if someone could give me a quick explanation on this topic or point me in a direction as to where to start learning about this.
Responsive ResidentBy default, the visual filter will be propagated to all DAX expressions. Whenever multiple contexts are operating on a single DAX expression(expression with calculate keyword), one context will be overridden by other. That's why sometimes you will see different results based on filter condition placement.
As already suggested go through the following links.
https://www.sqlbi.com/articles/row-context-and-filter-context-in-dax/
https://ptgmedia.pearsoncmg.com/images/9780735698352/samplepages/9780735698352.pdf