DAX Function Guide

ISINSCOPE
Empty image or helper icon

Sam McKay

CEO & Founder

How does the ISINSCOPE work?
HASONEFILTER function (DAX) returns TRUE when the number of directly filtered values on columnName is one; otherwise returns FALSE.
ISINSCOPE Formula Syntax
HASONEFILTER(<columnName>)
How do you use the ISINSCOPE?

It returns TRUE when the number of directly filtered values on columnName is one and only one. Otherwise, returns FALSE.

Related Blog Posts

Loading

Considerations when using the ISINSCOPE?

This function is similar to HASONEVALUE() with the difference that HASONEVALUE() works based on cross-filters while HASONEFILTER() works by a direct filter.

Related Video Tutorials

Loading

Formula examples using the ISINSCOPE
=IF(HASONEFILTER(ResellerSales_USD[ProductKey]),FILTERS(ResellerSales_USD[ProductKey]),BLANK()) 
Related Courses

Loading