How to Get Value Percentage based on Criteria in Table?

sophie23 — Fri, 02 Jul 2021 03:53:16 GMT

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 🙂

Re: How to Get Value Percentage based on Criteria in Table?

Anonymous — Fri, 02 Jul 2021 07:15:12 GMT

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.

topic How to Get Value Percentage based on Criteria in Table? in DAX Commands and Tips

How to Get Value Percentage based on Criteria in Table?

Re: How to Get Value Percentage based on Criteria in Table?