Hi Everyone
I am trying to use the ALLEXCEPT DAX function and keep getting the below error. I have tried variations of this, but cannot get it to work. Does anyone see anything wrong syntax-wise?
The "s1Counties" is a table and the "s1Counties[cnty_name]" is the column I do not want the filter removed from the
Formula: =ALLEXCEPT(s1Counties,s1Counties[cnty_name])
Error: "The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value."
Paul
I use 2007 as well, and I cannot find that function. Is it an add-in or a UDF?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
i think its a 2013 function
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
It is SQL Server 2012 function
http://technet.microsoft.com/en-us/l.../ee634795.aspx
Last edited by AlKey; 08-21-2013 at 06:06 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
OK, OP's profile says 2007, maybe it needs to be updated
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks