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.
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