Forum Discussion
DAX ISINSCOPE statement
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 ?
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_])
2 Replies
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.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_])
