Skip to main content

    Power BI

    Needs Votes

    Add 'average' option to Manage Aggregations

    Vote (3) Share
    Quinn's profile image

    Quinn on 21 Aug 2019 10:53:06

    Would it be possible to add 'Average' to the list of options in the Summarization drop down on the manage aggregations dialog box?

    Comments (1)
    Quinn's profile image Profile Picture

    Grant McKinnon on 06 Jul 2020 00:07:47

    RE: Add 'average' option to Manage Aggregations

    Don't need it, you can create a sum column and a count column then when you choose to create a average measure power bi internally will do a sum(sum) / sum(count) returning the average correctly.