+ Reply to Thread
Results 1 to 1 of 1

Power Pivot running total measure by criteria

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

    Power Pivot running total measure by criteria

    Hello,

    I have a pivot table where I've manged to get a running total for a give 'item' and stopped the returned value being duplicated,

    I thought the best way to do this would be keepfilters but could not get it to work, so wrote one measure

    Please Login or Register  to view this content.
    Whch gave a running totaal by each item, then put this measure in ;

    Please Login or Register  to view this content.
    the finished measure called NewT in attached workbook.

    This does give the result I was after but not sure if it's a very good way of doing it, if anyone have any better ideas please let me know
    work book attached showing all attempts.

    Richard.
    Attached Files Attached Files

+ 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] Power Pivot DAX running total by Months
    By Dicken in forum Office 365
    Replies: 2
    Last Post: 09-10-2022, 11:06 AM
  2. Replies: 0
    Last Post: 09-02-2022, 10:08 AM
  3. Replies: 0
    Last Post: 07-10-2022, 11:34 AM
  4. [SOLVED] Power Bi running total and power pivot
    By Dicken in forum Office 365
    Replies: 1
    Last Post: 07-08-2022, 02:15 PM
  5. power pivot DAX running total by criteria
    By Dicken in forum Office 365
    Replies: 0
    Last Post: 02-18-2022, 10:02 AM
  6. Pivot Table: Grand Total different measure from Column measure
    By chinneywow in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-07-2019, 06:22 AM
  7. Running total of a measure DAX
    By Hassan1977 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 12-29-2017, 10:32 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