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)
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.