Prevent aggregations

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

Answer 1

Use the Filter function in your DAX aggregations with All(Table) as the 1st argument.

Answer 2

Thanks David,

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

Many thanks and regards

Frank

Answer 3

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/