+ Reply to Thread
Results 1 to 2 of 2

Power Pivot Summarize Value By Category From Total

  1. #1
    Forum Contributor
    Join Date
    01-07-2004
    Posts
    314

    Power Pivot Summarize Value By Category From Total

    Hi all,

    Using Excel 2013.

    Trying to create a Calculated Column in a table to put Expense in 1 of 4 categories

    I came up with
    =CALCULATE(sum([TotalExpense]),FILTER(factExpense,factExpense[ExpnseType]="Sundries"))

    But that is returning total instead of a total for each record
    What did I miss?

    This works for the first Calculated column:
    =CALCULATE(sum([TotalExpense]),FILTER(dimExpense,dimExpense[Type]="Sundries"))

    But as soon as I copy the formula to the next column and update the type to "Wines_Spirits" I get

    A circular dependency was detected
    Found the answer on SQLBI website
    I added a unique id to each row and in Table Behavior in the Data Model set the Unique_ID as the Row_Identifier

    Works great!

    Link: http://sqlblog.com/blogs/alberto_fer...es-in-dax.aspx

    thx
    w
    Last edited by goss; 04-17-2014 at 05:57 PM. Reason: Update
    Kind regards,
    w

    http://dataprose.org

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Power Pivot Summarize Value By Category From Total

    Thanks for providing the solution.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ 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. Formula to multiply total number per category with the % of total
    By tantcu in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-13-2013, 07:18 PM
  2. formula - vba to summarize by money category
    By Fugazi_Dent in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-12-2013, 11:44 AM
  3. Pivot Chart Sub Total Category. Vary Colors
    By coreytroy in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-25-2013, 09:50 PM
  4. [SOLVED] How to summarize daily schedule by value and category?
    By briancox22 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 02-22-2013, 11:41 AM
  5. Replies: 2
    Last Post: 05-08-2006, 07:10 PM

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