Forum Discussion

manoplaeli's avatar
manoplaeli
Icon for Helper II rankHelper II
9 years ago
Solved

Quick calc percentage monthly

 

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/62566#M25762

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

Need Help
  • BhaveshPatel's avatar
    BhaveshPatel
    9 years ago

    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%

     

     

6 Replies

  • BhaveshPatel's avatar
    BhaveshPatel
    Icon for Super User rankSuper User
    9 years ago

    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's avatar
      manoplaeli
      Icon for Helper II rankHelper II
      9 years ago

      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)