Results 1 to 12 of 12

PowerPivot showing average instead of sum

Threaded View

  1. #1
    Registered User
    Join Date
    10-10-2022
    Location
    Cph, Denmark
    MS-Off Ver
    365 Enterprise
    Posts
    6

    PowerPivot showing average instead of sum

    Dear all

    I'm quite new to the world of Dax and Powerpivot.

    In this dataset I have the actual number of visits for sales reps in a certain district by store. This I did with a simple countrows function and it works...

    I also have a theoretical # of visits. This is a measure where I calculate how many visits the sales rep is actually expected to have conducted in a certain time period.
    This is calculated as a measure by multiplying the number of days selected in the pivot with the number of visits pr day expected (e.g. 30 days * 0,0328 visits/day = 0,98 visits (rounded up to 1) in a period of 30 days)

    The issue occurs in the pivottable, where the subtotals for visits are summed but the subtotals for theoretical visits are avaraged... (see pictures)

    Are there any quick fixes to make the pivot sum, instead of averaging, on the theoretical visits? (See attached picture)...

    (Probably difficult to answer without some data...but I'll have to anonymize it before uploading, if necessary)

    Thanks in advance

    mr_jules2
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 09-26-2020, 09:31 AM
  2. Help With DAX function for calculating Average PowerPivot
    By bconner in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-06-2020, 12:06 PM
  3. PowerPivot Weight Average w/ Filters
    By girlnamedP in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-23-2019, 03:25 PM
  4. [SOLVED] powerpivot calculation related showing error message
    By paxonltd in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-12-2019, 05:19 AM
  5. PowerPivot/PivotTable showing same results after relationship building.
    By saudi_red_neck in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 07-08-2018, 01:52 AM
  6. PowerPivot (2016) - hourly average and cumulative average ?
    By Cam in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-15-2016, 06:32 AM
  7. PowerPivot - Average of the values in a row
    By shadedrivein in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-14-2014, 06:16 PM

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