Forum Discussion
Missing DAX Functions SELECTEDVALUE and ISINSCOPE in Excel 365
Both are available on insider channel. That's only to wait when it'll be deployed on current channel, or shift on Beta. It is stable enough, the only you loss the compatibility with people on production versions.
Both are available on insider channel. That's only to wait when it'll be deployed on current channel, or shift on Beta. It is stable enough, the only you loss the compatibility with people on production versions.
Hi SergeiBaklan,
I just stumbled upon this issue and your answer. 🙂
I'm experiencing the same problem with a workbook I created in beta version 2409, which includes at least 50 measures using the functions ISINSCOPE and SELECTEDVALUE. I'm encountering major issues when other members of our organization, who are on the Current Channel, try to work with it.
Do you have any updates on when these functions might be available in the Current Channel?
Kind regards,
MarcusHave no idea, Microsoft doesn't share such information.
SergeiBaklan I am on the Beta Channel, always had access to these formulas but this changed early September 2023. It is causing alot of my Financial Reports to break.
My Questions:
1. Do you know why they removed these formulas?
2. I know the alternative to use for SELECTEDVALUE, but do you know what I can replace ISINSCOPE with?
I would really appreciate any feedback here as these 2 missing formulas is very disruptive to my business at the moment.
I make a quick test, both are available
where
Total:=IF( SELECTEDVALUE( Table1[B] ) = "x" , SUM( Table1[V]), 11 ) IsFiltered:=IF( ISINSCOPE(Table1[B]), "Yes","No")I'm on
Alternatives for ISINSCOPE() are
ISFILTERED() Hierarchies – DAX Patterns
HASONEVALUE() Distinguishing HASONEVALUE from ISINSCOPE - SQLBI
Thank you for sharing your knowledge and insights. Your assistance is greatly appreciated.
aarslans , you are welcome
