I need help with an Excel PowerPivot Formula (DAX?) RRS feed

  • Question

  • If I'm posting this in the wrong forum, please let me know.

    I have PowerPivot pulling in a table that looks something like:

    AAA 111

    AAA 222

    BBB 333

    CCC 444

    CCC 555

    For my report, I need to add a 3rd column that is the total (sum) of the values in the 2nd column, but only for those rows which have the same 1st column. 

    Using the same table above, the results would look something like:

    AAA 111 333

    AAA 222 333

    BBB 333 333

    CCC 444 999

    CCC 555 999

    I just could not figure out a way to do it with the DAX functions available in PowerPivot.

    • Changed type SuperSturgill Monday, December 3, 2012 12:51 PM Need Help
    Monday, December 3, 2012 10:50 AM