+ Reply to Thread
Results 1 to 3 of 3

ALL Function Filtering returned values

  1. #1
    Forum Contributor
    Join Date
    08-03-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    154

    ALL Function Filtering returned values

    Hi,
    This is a follow up to a question posed on Mr Excel,

    Please Login or Register  to view this content.
    It's to do with the ALL function, and what it actually returns, for example

    Please Login or Register  to view this content.

    Would return the correct result with all filters removed but

    Please Login or Register  to view this content.

    Would return a sum of the distinct values again all filters removed. Another interesting thing

    is that if you pout ALL(Table [Name] ) into DAX studio, you get a distinct table of values,
    but if you pout ALL(Table) , you get the entire table even if there are duplicate , in the table attached
    you'll see there are two B 5 's.

    Any help as to why this happens or reading suggestions welcome.


    Richard
    Attached Files Attached Files
    Last edited by Dicken; 06-06-2022 at 09:23 AM. Reason: Moderator request

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    60,469

    Re: ALL Function Filtering returned values

    Please post a link to the relevant thread on Mr Excel.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  3. #3
    Forum Contributor
    Join Date
    08-03-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    154

    Re: ALL Function Filtering returned values

    Done,

    Richard.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] values returned by index function without duplicates?
    By abhaydbo in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-17-2020, 07:33 AM
  2. Replies: 5
    Last Post: 01-03-2019, 05:40 PM
  3. [SOLVED] Values not returned by Index, Match when using values from Data Validation
    By Avinashch in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-10-2015, 10:34 AM
  4. Function values that change with filtering
    By cem.excel in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-22-2015, 04:51 PM
  5. SQL add returned values
    By Jollyfrog in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-21-2010, 06:25 AM
  6. Using the returned value of a function
    By adombrowski in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 12-21-2005, 03:01 AM
  7. Adjusting Values Returned by the RAND Function
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 08-29-2005, 10:59 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1