% of Total for one value in a column

[sy898661]

Hi!

I have a column in my query that lists Adherence to Schedule (Early, On Time, Late) and I want to find the % of On Time activities. How do I do this? I tried

STEP10 ATS % On Time = DIVIDE(COUNTAX('board-Query', 'board-Query'[STEP10 ATS Status] = "On Time"), COUNTA('board-Query'[STEP10 ATS Status]))

But that didnt work.

I want to show this as a line on the bar and line chart shown at the top to see what % of activities in each month is "On Time" for ATS.

The bar values show the Adherence to Date (which is differnt than ATS) but we want to see them together

Thank you 🙂

[parry2k]

@sy898661 you provided good detils but not enough to provide the solution. Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[sy898661]

I just realized I've asked this before but the answer I got is not working, just like in my first post it returns 1.00. here for reference:

STEP10 ATS % On Time = 

     VAR  CountofAllSTEP10 = DISTINCTCOUNT('board-Query'[STEP10 ATS Status])

     VAR CountofOnTimeSTEP10 = CALCULATE(CountofAllSTEP10, 'board-Query'[STEP10 ATS Status] = "On Time")

Return

     DIVIDE(CountofOnTimeSTEP10, CountofAllSTEP10)

[sy898661 · Accepted solution]

I figured out a way to do it!

its not the most efficient but it works so I guess thats all that matters for now:

I have my Step ATS column that lists the DATEDIFF between Step Actual and Plan completion in days

Then I have my Step ATS Status that says Early, On Time, or Late

Then I added these:

STEP10 ATS On Time = If('board-Query'[STEP10 ATS] = 0, 1, 0)

STEP10 ATS % On Time = DIVIDE(SUM('board-Query'[STEP10 ATS On Time]), COUNT('board-Query'[STEP10 ATS Status])) 

Again not efficient at ALL and now I have to do this 3 more times but at least its something!