Need percentage of values per each month

[richter2100]

I need help on displaying percentage of my data. I want a percentage per month, my created measue seems not working. I just counting the items per row, no numbers. 

Percentage OnTime =

COUNTROWS(FILTER('Table', 'Table'[OTD] = "On Time"))/COUNTROWS(ALL('Table'))

[kcantor · Accepted solution]

@richter2100 

Can you tell me how the graph is coming up with the numbers currently displayed? Do you have a calculation for that?

To start, I would create two calculations.

OnTime = CALCULATE(COUNTROWS(Table), [OTD] = "On Time")

All = COUNTROWS(Table)

% On Time = DIVIDE([OnTime], [All])

You could even write that into one calculation using VAR but the reason I suggest two calculations is so that you can verify the results to see where the breakage occurs.  Make the three calculations and put them in a matrix side by side. This method will give you the opportunity to check what you expect.  

BTW, in my calculation the filter is implied as it is part of CALCULATE. It will save some time. I believe your use of the FILTER is creating the disconnect as it is removing the filter from the entire table . . . even the time filter.

[richter2100]

thank you seems to work now!