Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
I follow this post but it is doen't works.
Solved! Go to 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.
Then I have created 3 calculated columns to get the Share and Direct % as shown below.
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)
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)
Are you writing measures??
Yes I wrote in meansure
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.
Then I have created 3 calculated columns to get the Share and Direct % as shown below.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |