locked
Prevent aggregations RRS feed

  • Question

  • I have a data warehouse with some very complex aggregations, which have been consolidated and proved for the entire organization. I'd like to show these aggregated values along the different hierarchies in PowerPivot. Thus, I must prevent PP from doing its own aggregations and showing the values from the imported tables directly.

    Is there any way to avoid aggregations and to show the 'original' values at higher levels of the hierarchies?

    Regards

    FB

    Wednesday, August 22, 2012 9:15 AM

Answers

  • Use the Filter function in your DAX aggregations with All(Table) as the 1st argument.
    Wednesday, August 22, 2012 3:54 PM
  • Hi fbackes,

    As long as your report is showing one category value per aggregate, you will get the underlying supplied value.  If you are reporting at a level in which multiple categories are represented, you would have to tell PowerPivot how to deal with the multiple values, either by using AVG, MIN, MAX, etc.   Is this your case?




    Javier Guillen
    http://javierguillen.wordpress.com/

    Friday, August 24, 2012 7:06 PM
    Answerer

All replies

  • Use the Filter function in your DAX aggregations with All(Table) as the 1st argument.
    Wednesday, August 22, 2012 3:54 PM
  • Thanks David,

    could you supply a little example, please? I'm totally new to PP.

    Many thanks and regards

    Frank

    Wednesday, August 22, 2012 4:03 PM
  • Hi fbackes,

    As long as your report is showing one category value per aggregate, you will get the underlying supplied value.  If you are reporting at a level in which multiple categories are represented, you would have to tell PowerPivot how to deal with the multiple values, either by using AVG, MIN, MAX, etc.   Is this your case?




    Javier Guillen
    http://javierguillen.wordpress.com/

    Friday, August 24, 2012 7:06 PM
    Answerer