Search code examples
powerbisumdaxcumulative-sum

Get a Department Percent Contribution of Total Sales

    Table = opportunity
    Dimension Field = Territory
    Measure Field = AnnualSales

I want a measure that will take a territories SUM(AnnualSales) and see what percentage it makes of All territories SUM(AnnualSales) would be. I have not been able to accomplish this based off the articles I've read so far. Any help is greatly appreciated

My results would look something like this.

Solution

  • If you want to see results in a table of visualization:

    create this measure: CALCULATE(SUM(AnnualSales))

    then, drag Territory field in a table, add the new measure created in the table and then go to visualization editor right click on measure and click on show results as a percent of column total.

    Waiting your answer ... :)

    Regards