danielle_thoma1's avatar
danielle_thoma1
New Member
8 years ago
Status:
Needs Votes

None Aggregation Function to Handle Pre-Aggregated Data

Add a "None" aggregation function that would allow pre-aggregated data to be displayed as is in Power BI visuals. We have several data sets where the data has already been aggregated. This is causing the data to be incorrectly displayed in Power BI when trying to do a drill-up / drill-down as we're forced to select an aggregation function (SUM, MAX, MIN, etc.). Examples of pre-aggregated data are price indices calculated for each level of a product hierarchy or data calculated at each level of a geography hierarchy to suppress some values at lower levels of the geography for confidentiality reasons. The use of a "None" aggregation in a Power BI visual / matrix would display the pre-calculated value for the selected hierarchy level as-is from the underlying data set instead of trying to re-aggregated data that's already been aggregated.

2 Comments

Recent ideas