Skip to main content
Microsoft Idea

Power BI

Needs Votes

None Aggregation Function to Handle Pre-Aggregated Data

Vote (12) Share
Danielle Thomas's profile image

Danielle Thomas on 03 Apr 2018 19:44:14

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.

Comments (1)
Danielle Thomas's profile image Profile Picture

Danielle Thomas on 05 Jul 2020 23:35:34

RE: None Aggregation Function to Handle Pre-Aggregated Data

See the comments dated ‎10-28-2016 & ‎06-27-2018 in: https://community.powerbi.com/t5/Desktop/Pre-Aggregated-Data/m-p/54519#M22068.