Našimi kurzy prošlo více než 10 000+ účastníků
2 392 ověřených referencí účastníků našich kurzů. Přesvědčte se sami
ISFILTERED vs ISINSCOPE – basic difference
How are ISFILTERED and ISINSCOPE different, and are they different at all?
In many visuals there is no difference. Both functions controls whether some value is evaluated in some context.
LIke here, in grouping by brands and models, the results are equal.
- isfiltered = ISFILTERED(Sheet1[Model])
-
isinscope = ISINSCOPE(Sheet1[Model])
hen do the functions start to differ?
If we use filtering from the outside, i.e. with another visual or a page filter. While ISINSCOPE does not capture this filtering, ISFILTERED takes it into account, see image:
