Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Calculating Percentages

So I have this calculated table (I derived the table using a CALCULATE()), that looks like this.   Dept Location No of Ppl Sales USA 40 Sales Denmark 20 Sales Sweden 40 Sales...
Need Help
Show and Tell
  • Sean's avatar
    Sean
    9 years ago

    Anonymous

    Okay if you really want COLUMNS here are those formulas...

     

    Total People COLUMN = CALCULATE ( SUM ( 'Table'[No of Ppl] ), ALLEXCEPT('Table', 'Table'[Dept]) )

Percentage COLUMN = DIVIDE ( 'Table'[No of Ppl], 'Table'[Total People COLUMN], 0 )

    But in case you want MEASURES

     

    Total People MEASURE = CALCULATE ( SUM ( 'Table'[No of Ppl] ), ALLEXCEPT('Table', 'Table'[Dept] ) )

Percentage MEASURE = DIVIDE ( SUM('Table'[No of Ppl]), [Total People MEASURE], 0)

    Hope this helps!

    Good Luck! :smileyhappy:

     

Simona0926's avatar
Simona0926
Microsoft Employee
5 years ago

Hey all,

I am trying to find a measure that would help me to see the percentage of each status for each AREA.

 

Example: I have a total of 40 tickets from which 20 on WE and 20 on MEA.

I want to see what % of the total on WE are completed.

At this moment I have the option to see only the % of the total (40 tickets).

 

I would like to highlight the fact that the chart used is columns (not tables).

 

Thank you so much in advance.