22 สิงหาคม 2555 9:15
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?
22 สิงหาคม 2555 15:54Use the Filter function in your DAX aggregations with All(Table) as the 1st argument.
22 สิงหาคม 2555 16:03
could you supply a little example, please? I'm totally new to PP.
Many thanks and regards
24 สิงหาคม 2555 19:06
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?