ISINSCOPE

Syntax

ISINSCOPE(<columnName>)

Tutorial with example

The DAX function ISINSCOPE, allow us to work with hierarchies in Power BI. In this video I will go through an example on how to do that. This DAX function was introduced in the November 2018 Power BI Desktop Update, so make sure you have that installed if you wan to test it out.

Tutorial (part 2)

In today’s video I am going to show you how you can remove blanks from hierarchies using the DAX Function ISINSCOPE. I have covered ISINSCOPE before with a more difficult example, so I hope this video will explain it in easier terms and with a useful example.

Download example file:

Download Power BI file: here.

Remarks