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 have an a Powerbi Table showing a criteria if a phase has been started on time or delayed.
This is based on an additional column that shows "Not started" "On time" or "Delayed" based on the planned and actual dates.
Help needed: Can someone help guide me on how I can get the percentage of the values in each criteria (depending on whether they not started, on time, or delayed)?
For example, the result I want to see is:
Out of the 10 projects,
78% of the project phases is not started
22% are on time
0% are delayed
Appreciate your inputs 🙂
Hi @sophie23 .
Based on what I understood from your query, please follow the below steps in order to achieve that functionality.
1)Calculate Total Conditions using COUNT.
Total=COUNT(Table(Column))
2)Then calculate Count of specific criteria;
For example,
i)CountOfNotStarted=CALCULATE(COUNT(StartDate),filter(table,StartDate="Not Started")
ii)CountOfOnTime=CALCULATE(COUNT(StartDate),filter(table,StartDate="On time")
iii)CountOfDelayed=CALCULATE(COUNT(StartDate),filter(table,StartDate="Delayed").
3)Then use DIVIDE to calculate percentage.
i)%NotStarted=DIVIDE(Total,CountOfNotStarted).
ii)%OnTime=DIVIDE(Total,%OnTime).
iii)%Delayed=DIVIDE(Delayed,%Delayed).
4)In Measure tools, change its display type to %.
If this is what you are looking for, then please mark it as 'Accept as Solution' so that others could find it easily.
Regards,
Sanket Bhagwat.
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 |
---|---|
41 | |
19 | |
19 | |
16 | |
15 |
User | Count |
---|---|
49 | |
26 | |
22 | |
17 | |
16 |