Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

    Percent of Total (rows/columns) FOR OLAP CUBES

    Vote (15) Share
    Richard Goerwitz's profile image

    Richard Goerwitz on 23 Nov 2016 04:32:14

    Percent of Total (rows/columns) is still needed FOR OLAP CUBES.

    Excel has no trouble with this.

    But Power BI still cannot express values from OLAP cubes as percentages of the row or column total, forcing users to either go to Excel, or else go back to their admins and put these calculations into the cubes themselves (nullifying the self-service advantage of Power BI and causing administrators to curse under their breath :-)).

    Comments (1)
    Richard Goerwitz's profile image Profile Picture

    MA Roberts on 05 Jul 2020 22:38:43

    RE: Percent of Total (rows/columns) FOR OLAP CUBES

    I would add: also a "Percent of Grand Total", just as you can do in Excel. It is just so painful that this isn't part of the table / matrix functions for a Cube - things that Excel does simply and elegantly that are a royal pain to accomplish in Power BI.