Filtering Calculation

[Anonymous]

Hello all,

Below is an example of the data I am looking to manipulate via Dax.  I want to ensure that as I filter by the week and consolidate the products into one Service % or if I filter to get the YTD view the % stays true to the sum of the loads by the sum of the lates.  I have been bringing in different versions of the table with different SQL statements, but I want to bring in one table and manipulate via DAX functions.  The % is throwing me off because if I use the AVG in my visuals it is mostly not accurate.  

Thanks all

Year	Commodity	Week	Load	Late	Service %
2020	Toys	1	25	3	88%
2020	Games	1	47	13	72%
2020	Toys	2	25	14
2020	Games	2	15	3

[Anonymous]

Everyday we deliver loads and we track late deliveries to come to a service % ((Loads-Lates)/Loads).  That is the calculation I am looking to create via DAX.  I want the Service % to be accurately reflected as I look at the data by week, month, year for example.  I also want to be able to look at the data by service % combining the commodity while look at it by the same time manipulation.  

I have created multiple tables from the daily data via grouping in Power query, but I know there is a better way via DAX.

[daxer-almighty]

Unclear. Can you please elaborate? We want a clear, step-by-step example of the calculation. Thanks.