isInscope for SSAS 2017

[Stawik]

Hi All

I want to use switch and change measue for user depending where in hierarchy he is.

I made it nicelly with is in scope, but I can not use it in SSAS 2017, as this is not avaiable.

Isfiltered is not so good as isInscope, becouse if user will choose some value in top filter (in Excel) then this is always reporting some measue as true and it change my value.

For example I have 3 levels of geography hierarchy.

Continent, Country, Region

Users have three different plans on each level. For example, Continent is 1000, Country 1100 and Region 1200.

I want to show it on different levels.

I'm using switch and is filtered to get the correct results.

My measure looks like this

Target:=
SWITCH(TRUE();
        
            ISFILTERED('Sales'[Continent]);
                SWITCH
                    ( 
                	    TRUE();
	                    ISFILTERED('Sales'[Continent] && NOT(ISFILTERED('Sales'[Country]))&& NOT(ISFILTERED('Sales'[Region])) ;[Continent target];
	                    ISFILTERED('Sales'[Continent] && ISFILTERED('Sales'[Country]) && NOT(ISFILTERED('Sales'[Region])) ;[Region target];
                        ISFILTERED('Sales'[Continent] && ISFILTERED('Sales'[Country]) && ISFILTERED('Sales'[Region]) ;[Country target];
		                [Continent target];
                    );
                -1;
	-1
)

And it works fine until someone will not filter some region (in filter area in Excel pivot). Since that moment Sales[Region] is always filtered.
Does any one ahve some idea how to solve that. With IsInScope it works fine, but it's not present in SSAS 2017.

Best regards

Daniel

[v-xicai]

Hi @Stawik ,

Yes, the ISINSCOPE function is unavailable in SSAS using connect live mode, while you may choose the Import mode instead of connect live mode.

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Stawik]

The problem is that I'm using it in Excel, so I can't use this workarround, I have to change my Measure.