Quick calc percentage monthly

[manoplaeli]

I am working on employee time and I use quick Calc to show percentage but it show as total as in in the picture. I want to show the percentage of Direct vs Share by monthly. As you can see here if I show this in the graph it doesn't not add up to 100% monthly. 

http://community.powerbi.com/t5/Desktop/How-to-display-the-graph-in-percentage-for-daily-monthly/m-p...

I follow this post but it is doen't works.

[BhaveshPatel]

Hi @manoplaeli

Write three measures to visulize this.

DirectHours:=CALCULATE(SUM(Table1[Hours]), FILTER(Table1, Table1[Cost]="Direct"))

ShareHours:=CALCULATE(SUM(Table1[Hours]), FILTER(Table1, Table1[Cost]="Share"))

Percentages:=DIVIDE([DirectHours],[ShareHours],2)

[manoplaeli]

Thanks, @BhaveshPatel

Below is the fomular in my table. It only show me Direct Cost.

DirectHours = CALCULATE(SUM('Timesheet Details TSR01'[Hours]),FILTER('Timesheet Details TSR01','Timesheet Details TSR01'[Cost]="Direct Cost"))

ShareHours = CALCULATE(SUM('Timesheet Details TSR01'[Hours]),FILTER('Timesheet Details TSR01','Timesheet Details TSR01'[Cost]="Share Cost"))

Percentage = DIVIDE([DirectHours],[ShareHours],2)

[BhaveshPatel]

Are you writing measures??

[manoplaeli]

Yes I wrote in meansure

[BhaveshPatel · Accepted solution]

Hi @manoplaeli

I think I misunderstood your problem initially.

I have partially used Query Editor to get the correct results.

I have pivoted the hours column to get the correct data structure in order to solve this problem. There are other solutions as well but I find this convenient.

Pivot

Then I have created 3 calculated columns to get the Share and Direct % as shown below.

Results of the pivot columnSHARE%

[manoplaeli]

Hi @BhaveshPatel

Thank you very much I got it works now,

Best,