Resolved: calculate with and without filter.
How select choose which of them? slicer senstive is calc. with filter func?
4 answers ( 1 marked as helpful)
sorry, can you please elaborate a bit more, I am not sure I understand the question
Sorry my bad, so example I need filtre something in calculation. How decide I must use filter function in calculate or direct write equation in calculate without filter function.
The most important thing to remember is how they interact with existing slicers.
Direct Filters: These are "aggressive." If you have a slicer on your page for "Blue" products, but your measure says Product[Color] = "Red", the measure will ignore the slicer and show Red.
FILTER(Table, ...): These are "additive." If you use FILTER('Product', 'Product'[Color] = "Red"), it only looks at the products already visible in the current filter context. If a user slicers to "Blue," the FILTER function looks at the "Blue" list, finds no "Red" rows, and returns blank.
Direct Filters: These are "aggressive." If you have a slicer on your page for "Blue" products, but your measure says Product[Color] = "Red", the measure will ignore the slicer and show Red.
FILTER(Table, ...): These are "additive." If you use FILTER('Product', 'Product'[Color] = "Red"), it only looks at the products already visible in the current filter context. If a user slicers to "Blue," the FILTER function looks at the "Blue" list, finds no "Red" rows, and returns blank.
Thanks teacher.