Results 1 to 5 of 5

DAX ALLEXCEPT vs ALL & VALUES

Threaded View

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

    DAX ALLEXCEPT vs ALL & VALUES

    Hi have a pivot table where I have used ;

     justItemAll_Values:=CALCULATE( [Tsales], ALL( Table1) , VALUES( Table1[Item]))
    and

         JustItemAllXcept:=CALCULATE( [Tsales] , ALLEXCEPT(Table1,Table1[Item]))
    in the pivot these both give the same result a total for the items ignore everything else, this is attached,
    but if I go to studio or Table Edit DAX and run the following

    EVALUATE
    ADDCOLUMNS( Table1,
    "N", CALCULATE( [Tsales] , ALLEXCEPT(Table1,Table1[Item])))

    EVALUATE
    ADDCOLUMNS( Table1,
    "M", CALCULATE( [Tsales], ALL( Table1), VALUES( Table1[Item] ) ))



    I get two different result the all values seems to ignore the values and bring back the overall total? what am I doing wrong?

    Richard.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. DAX Calculated column ALLEXCEPT v ALL / Values;
    By Dicken in forum Office 365
    Replies: 4
    Last Post: 09-19-2023, 10:28 AM
  2. Dax allexcept
    By Dicken in forum Office 365
    Replies: 1
    Last Post: 04-09-2023, 02:28 PM
  3. DAX ALLEXCEPT vs ALL & VALUES
    By Dicken in forum Office 365
    Replies: 0
    Last Post: 03-31-2023, 09:37 AM
  4. Dax allexcept
    By Dicken in forum Office 365
    Replies: 0
    Last Post: 01-28-2023, 09:56 AM
  5. DAX ALLEXCEPT versus ALL & VALUES in Power Pivot
    By Dicken in forum Office 365
    Replies: 4
    Last Post: 08-04-2022, 09:17 AM
  6. Replies: 0
    Last Post: 07-10-2022, 11:34 AM
  7. assigning date entries to week values and month values to sum column C-N values C-
    By the accountant in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-20-2010, 09:52 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