Handy in matrix visuals, this DAX check returns TRUE if a given column is the grouping level being computed right now within a hierarchy, so each level can use its own logic.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains ISINSCOPE in context, with comparison tables and the common traps.
Terms in this definition
- Matrix
Like a table, but able to lay values out in stepped form over several dimensions, total them automatically and drill down through hierarchies; a Power BI visual.
- DAX
Short for Data Analysis Expressions, the formula language you write measures, calculated columns and row-level security rules in, within tabular semantic models in Power BI, Excel Power Pivot or Analysis Services.
- Hierarchy
Lets report users drill up and down through totals by stacking a dimension's levels in order, for example region, then city, then address, in a semantic model.
Related terms
- Information functions
ISBLANK, ISFILTERED, ISCROSSFILTERED, ISINSCOPE and HASONEVALUE all belong to this DAX family, whose members inspect a value or check what filters currently apply.