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:

Leave a Reply

Your email address will not be published.


clear formPost comment