Solved: Re: DAX ISINSCOPE statement

Anonymous · ‎03-13-2019

Hi Team

I am going to use the new DAX function ISINSCOPE, but is not available when connection type is LIVE (SSAS tabular)

When will this be available ?

Anonymous · ‎03-14-2019

Hi Maggie

I have found a workaround by using ISFILTERED which seems to work.

The issue was to hide blank members in ragged heirachy.

This peace of DAX seem to work:

Amount period budg:= SWITCH(TRUE(); AND(ISFILTERED(Kontoheiraki[Level3]);ISBLANK(VALUES(Kontoheiraki[Level3]))); BLANK(); BudgetTransaction[Amount period Budg_])

View solution in original post

v-juanli-msft · ‎03-14-2019

Hi @Anonymous

Check if you download the lastest version :March 2019 Update (2.65.5313.501) (File->Help->About),

As searched, i can't find any document saying when the new function would be possible in SQL Server Analysis Services.

You may try other function which has similar function as " ISINSCOPE", like "HASONEVALUE",ect.

If possible, you could share your problem here so i can find some workaround for you.

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous · ‎03-14-2019

Hi Maggie

I have found a workaround by using ISFILTERED which seems to work.

The issue was to hide blank members in ragged heirachy.

This peace of DAX seem to work:

Amount period budg:= SWITCH(TRUE(); AND(ISFILTERED(Kontoheiraki[Level3]);ISBLANK(VALUES(Kontoheiraki[Level3]))); BLANK(); BudgetTransaction[Amount period Budg_])